If you use the "for update" clause on a select, the database locks all the
rows that satisfy the query. If the database is unable to lock all the rows,
it raises an exception. Use this with care.
"C Chang" <cschang_at_maxinter.net> wrote in message
news:3CDB495D.6DF_at_maxinter.net...
> I have a procedure to update part of records that belong to certain site
> ( such as reginal bank). Can I lock up that part of records, so no other
> user can enter new records belonging to that location? The new records
> are entered through sqlldr process? I have no clue to this. Do i need a
> trigger or? I will appreciate anyone for a learning tip.
>
> C Chang
Received on Fri May 10 2002 - 08:16:10 CDT
