What is the syntax in SQLServer for Oracle's SQL:
select *
from tab1
for update of tab1.col1 nowait
by Ng K C Pa » Tue, 29 Sep 1998 04:00:00
select *
from tab1
for update of tab1.col1 nowait
1. Select for update nowait returns an error
When I used the below command where ttt is the table name which have two
columns(col1,col2):
select * from ttt where col2='India' for update nowait
I am getting an Error: ORA-01002: fetch out of sequence
What could be the reason. I have not having the problem from Oracle.But when
I give the above sql statement in Java(JDBC). Our database is Oracle 8.0.5
Thanks
Nicolas
2. Will JSQL replace PL/SQL one day?
4. NewEra 3.0
6. Where is select for update nowait skip locked documented?
8. REPOST: Where is select for update nowait skip locked documented?
9. Select... for update (nowait)
11. FOR UPDATE OF and NOWAIT questions
12. REPOST: FOR UPDATE OF and NOWAIT questions