How to delete the first ten data

剥夺者

I want to submit every 10 records deleted, is there no delete top 10 method in oracle?

woshenming

delete from table1
where id in (select top 10 id from table1...)...

剥夺者

delete from T3TN01_REGUL_STK_WORK where id in(select top 10 id from T3TN01_REGUL_STK_WORK where PROC_FLG = '1')

whbilly

for example:

select r,e.* from (select rownum r,last_name,salary from (
select last_name,salary from employees order by nvl(salary,0) desc)) e
where r <11;

旋律de茶叶

delete from table where rowid in (Select rowid from table where rownum <=10);
commit;

panda_ren

旋律de茶叶positive solution

kiss01

Use rownum

aeoluschen

delete from table where rownum<11;
This seems to work.
I don't understand the commit behind旋律de茶叶; what does it mean? Who will talk about it!

whbilly

Commit is to submit the transaction, otherwise, the dml update is not written into the data file of the database, and it is still in memory