"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA7033105D2_at_lnewton.leeds.lfs.co.uk...
> select whatever
> from tablename
> where condition
> FOR UPDATE;
>
> Now, if there are no locks on those rows, you have selected and locked
> them. When you rollback or commit, the locks will be released. As usual,
> the where clause is optional, but if you want to lock the entire table
> you could use :
That doesn't stop what Francky asked for, which is a second session
selecting those rows. It may of course do the job he actually wants.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Jan 20 2003 - 06:06:51 CST
