question on row locking 1

[slok]

when deleting from a record from a table...

how can I lock it for delete.

I tried something like that..

==
select emp_no from employee where emp_no = '1'
for delete nowait;
==

in SQLPlus, it gives me an error message
===
ERROR at line 1:
ORA-00905: missing keyword
==


What could be wrong?

 

[karluk]

Have you looked at the "lock table" command? Most likely that will do what you want.

 

[sem]

There no special option for locking to delete:

select emp_no from employee where emp_no = '1'
for update nowait;