Re: simple SQL question

From: BHAVESH PATEL <BHAVESH-PATEL_at_worldnet.att.net>
Date: Wed, 11 Aug 1999 07:37:56 -0400
Message-ID: <7orn6s$4r9$1@bgtnsc02.worldnet.att.net>

You have to use a sequence in order to do that. Have a single column which increments sequence on every insert, and then you can retrieve based on the sequence.

-Bhavesh
kev wrote in message <37A82185.A36F8334_at_fast.no>...
>Hi,
>
>Just wondering - what's the best way to retrieve, say, the latest ten
>entries to a table.
>Does Oracle have a MAXROWS func (I couldn't find one in the docs)
>
>Thanks,
>
>- Kev
>
Received on Wed Aug 11 1999 - 06:37:56 CDT