How to Lock a table or record in the Oracle using query
Posted on 2005-04-15
I want to lock the table using the query in oracle so can any body tell how I will do the same I know how to lock the table in SQLServer as
update <table> set <field>=<value> where <condition>
This will lock the table. You can open another query analyzer window/session in sqlserver, and run a select * from <table>, it will block.
the same thing i want to do in oracle so can anybody tell me how I can do this in oracle