Home » RDBMS Server » Server Administration » Re: SET TRANSACTION
Re: SET TRANSACTION [message #374919] Wed, 11 July 2001 14:43
andrew again
Messages: 2577
Registered: March 2000
Senior Member
lock table TABLE1 in share mode;
Locks released on COMMIT or ROLLBACK

Usually explicit locks are not required.

Also see
select * from my_tab
where col1 > 10
FOR UPDATE;

http://www.ss64.demon.co.uk/ora/lock.html

Report message to a moderator

Previous Topic: Importing french accent data in Oracle
Next Topic: Re: Restore using an update command
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 02:18:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.