Re: simple SQL question
From: BHAVESH PATEL <BHAVESH-PATEL_at_worldnet.att.net>
Date: 1999/08/11
Message-ID: <7orn6s$4r9$1_at_bgtnsc02.worldnet.att.net>#1/1
Date: 1999/08/11
Message-ID: <7orn6s$4r9$1_at_bgtnsc02.worldnet.att.net>#1/1
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 - 00:00:00 CEST