Re: deleting rows from a table

If you simply want to remove an arbitrary 200 rows from your table then using something like

DELETE FROM MyTable
WHERE ROWNUM <= 200;

I can't vouch for how 'random' the 200 records removed will be though.

--
Alan D. Mills

>I want to delete 200 rows from a table which has 1000 rows. The rows can be
>chosen in a random order.
>
Received on Thu Jul 30 1998 - 09:25:28 CDT