Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: help with query :)
George, that is certainly true.
A number(12,0) column populated with trigger and a sequence is the only way I can think of to retrieve the most recently inserted rows from a table.
Jared
On Thu, 1 Jun 2000 George.Brennan_at_warnermusic.com wrote:
> Possibly, but Oracle is quite capable of inserting more than 10 records with the same timestamp in a multiuser application.
>
> George.
>
> > -----Original Message-----
> > From: "Yohans Mendoza" <yohans_at_demiurge.sirius-images.net>
> > [mailto:yohans_at_demiurge.sirius-images.net]
> > Sent: Wednesday, May 31, 2000 6:32 PM
> > To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]
> > Subject: RE: help with query :)
> >
> >
> > what about ordering the records by the time stamp ( na column
> > I have for
> > the record creation) and use the ROWCOUNT < 10?
> > will it work?
> >
> > Thank you all for your responses!
> > --Yohans
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > ~~~~~~~~~~~~~~~~~
> > Yohans Mendoza System Analyst
> > yohans_at_sirius-images.com Sirius Images Inc.
> > http://www.sirius-images.net/users/yohans
> > http://www.sirius-images.com
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > ~~~~~~~~~~~~~~~~~
> >
> > On Wed, 31 May 2000 George.Brennan_at_warnermusic.com wrote:
> >
> > > 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).
> > > >
> > > >
> > >
> > >
> > > --
> > > Author:
> > > INET: George.Brennan_at_warnermusic.com
> > >
> > > 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).
> > >
> >
> > --
> > Author: Yohans Mendoza
> > INET: yohans_at_demiurge.sirius-images.net
> >
> > 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).
> >
> >
>
>
> --
> Author:
> INET: George.Brennan_at_warnermusic.com
>
> 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).
>
Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Received on Thu Jun 01 2000 - 11:35:12 CDT