RE: help with query :)

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
Received on Thu Jun 01 2000 - 04:09:05 CDT