Re: Finding out last 10 records

No, it will not work. You cannot use ROWID to sort records to get 'insert-order'. It is wrong.

And you have to use dynamic view if you want ORDER BY and use ROWNUM.

Jan Pruner
> -----Original Message-----
> Sent: Wednesday, August 14, 2002 9:13 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Santosh,
>
> If I understand your requirement correctly, this could be the solution
>
> for first 10 records :
> select * from TABLE_NAME where rownum<=10 order by rowid;
> for last 10 records :
> select * from contract where rownum<=10 order by rowid desc;
>
> MILIND SHITOLE
> milinds_at_sage.co.za
>
>
> From: "Amjad Saiyed" <amjad_at_medicomsoft.com>
>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Finding out last 10 records
> >Date: Wed, 14 Aug 2002 04:28:24 -0800
> >
> >i thought santosh wanted records based on value that is 1st 10 minimal
> >values and last 10 max values...well if this is not the case than the
> >solution that i had send using rownum is obsolete and hence ignore it....
> >
> >rgds,
> >Ams.
> >www.medicomsoft.com.
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Alexandre
> >Gorbatchev
> > Sent: Wednesday, August 14, 2002 3:08 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Finding out last 10 records
> >
> >
> > Santosh,
> >
> > There is no "last" and "first" records in relational databases in terms
> >of
> >location. All records are equal and may be stored physically anywhere. I
> >guess that may be possible (parsing ROWID and using information about
> >extent
> >location) to sort records by extent, block and number of record inside
> >block, but that's not a trivial task.
> > If you need to select last 10 inserted records, make a trigger with
> >filling a timestamp into a column and select with sort by this column
> > using rownum in where condition.
> >
> > Alexandre
> > ----- Original Message -----
> > From: Santosh Varma
> > To: Multiple recipients of list ORACLE-L
> > Sent: Wednesday, August 14, 2002 11:48 AM
> > Subject: Finding out last 10 records
> >
> >
> > Hello all
> > Could any one of you guide me on how to select last 10 records
> >from
> >a table. and also finding out first 10 records..
> >
> > Thanks and regards,
> >
> > Santosh
>
> _________________________________________________________________
> Join the world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com

-- 
         Pruner Jan
       jan_at_pruner.cz
     http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

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).