Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


oracle locking with select for update of


oracle locking with select for update of  using -'sql,oracle,plsql,locking'

I'm selecting from tables FOO and BAR.  I'd like to lock the records of FOO which are being returned, but I don't want the records of BAR to be locked.

cursor c_foobar is
select foo.*, bar.* from
foo, bar
where foo.id = bar.foo_id
for update of <what should I put here?>


It seems like I need to specify individual columns, but I want the entire record of foo to be locked.  e.g. I wish I could do something like:

cursor c_foobar is
select foo.*, bar.* from
foo, bar
where foo.id = bar.foo_id
for update of foo


Do I have to enumerate every column of foo in the for update of section in order to lock them all?  Or can I arbitrarily choose any column in foo, even those which are not its primary key, and it will lock the entire record?
    

asked Sep 29, 2015 by jekbishnoi
0 votes
2 views



Related Hot Questions



Government Jobs Opening


...