Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: help with query :)

RE: help with query :)

From: <George.Brennan_at_warnermusic.com>
Date: Wed, 31 May 2000 9:01:19 GMT
Message-Id: <10514.107224@fatcity.com>


That will only retrieve the first 10 rows not the last 10 entered. That needs an identifying column, such as a sequence based trigger or auditing.

George,

> -----Original Message-----
> From: "Abdul Aleem" <abchaudhary-ho_at_beaconhouse.edu.pk>
> [mailto:abchaudhary-ho_at_beaconhouse.edu.pk]
> Sent: Wednesday, May 31, 2000 8:59 AM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: RE: help with query :)
>
>
> In your WHERE clause try adding ROWCOUNT < 10;
>
> Regards,
>
> Aleem
>
> -----Original Message-----
> From: Yohans Mendoza
> [mailto:yohans_at_demiurge.sirius-images.net]
> <mailto:[mailto:yohans_at_demiurge.sirius-images.net]>
> Sent: 31 May, 2000 5:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: help with query :)
>
> hi all,
>
> hope you're ok
> I have this "silly" question. Is there an easy way to
> retrieve the last 10
> records that have been entered in a given table?
>
> TIA
>
> --Yohans
>
> --
> Author: Abdul Aleem
> INET: abchaudhary-ho_at_beaconhouse.edu.pk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 31 2000 - 04:01:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US