Re: delete all records except fist through trigger

That will not give a reasonable result. There is no concept of a "first" record in a table of a relational database. The fact that there is always a first row returned by a cursor is irrelevant. I have seen cases where there is a "seed" row in a table, but in all such cases it also has a known key value which is distinct from legitimate values.

mcmreddy_at_bioch.tamu.edu wrote:

> delete * from (table_name)
> where rownum > 1 ;
Received on Mon Aug 16 1999 - 07:33:36 CDT