Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can I lock up partial set of records in a table?

Can I lock up partial set of records in a table?

From: C Chang <cschang_at_maxinter.net>
Date: Fri, 10 May 2002 00:15:25 -0400
Message-ID: <3CDB495D.6DF@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 Thu May 09 2002 - 23:15:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US