Re: select question

On Tue, 18 Mar 2003 10:57:39 +0800, "music4" <music4_at_163.net> wrote:

>If you have any idea on this problem, please help me!

• Upgrade to something supported. I don't know how you license can be 'cheap' because your license is basically void
• put the statement in a cursor

cursor ...
select ..
from table
where status = 0
for update of status --- this is the important part.

open <cursor>
fetch cursor into variable
loop
....

update table
-- here is the important part
where current of <cursor>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 18 2003 - 00:55:24 CST