JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Henrique Sousa<br />SCJP 1.4<br /> <br />All men die, not all men really live - Braveheart, 1995
delete from your_table where rowid <= 50000 (of course, I assumed rowid starts with 1)
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Originally posted by Shailesh Chandra: delete from your_table where rowid <= 50000 (of course, I assumed rowid starts with 1)<hr></blockquote> I think in Oracle it should be like delete from your_table where rownum < 50001 [/QB]