last n rows

[Anon]

Hi,
I have to delete the last 'n' rows(lets say 100 rows in table with 1000 rows)in oracle database ?

How do i do it ?

thanx in adv.
satish

[Anon]

if you have got auto_incremented id field in your table it is not a problem...

[Anon]

Hi,
You can use pseudo column name as rownum in oracle to delete last n rows. Also check rowid pseudo column

Bye

[Anon]

Hi,
i know that we have to use rownum,rowid for this ? but how ?

thanks
satish