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 > [EMAIL PROTECTED] > > > From: "Amjad Saiyed" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
