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: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Fri, 2 Jun 2000 11:35:56 +0500
Message-Id: <10515.107513@fatcity.com>


I think superb. It should work for the last records though you'll create DESCENDING index.

		-----Original Message-----
		From:	Yohans Mendoza
[mailto:yohans_at_demiurge.sirius-images.net]
		Sent:	31 May, 2000 10:32 PM
		To:	Multiple recipients of list ORACLE-L
		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).
Received on Fri Jun 02 2000 - 01:35:56 CDT

Original text of this message

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