"rowcount" does not really exist as part of the data. It is something generated at the moment of retrieving the data from the database, so you cannot use it to delete or update rows.
One option could be the rowid, but depending on what you want to accomplish, I think a better option is to use a cursor for loop, defining your cursor as "for update", in order to be able to take advantage of the "where current of" condition.
<pre>create or replace procedure TEST is
cursor test_cursor is select * from your_table for update;
for i in test_cursor loop
delete from your_table where current of test_cursor;
Last Wiki Answer Submitted: October 3, 2008 11:52 pm by carlosdl63,535 pts.