OraFAQ Forum: Reports & Discoverer » Select/sort rows from a table in "insertion" order.

Home » Developer & Programmer » Reports & Discoverer » Select/sort rows from a table in "insertion" order.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Select/sort rows from a table in "insertion" order. [message #225729]

Wed, 21 March 2007 02:47

creativerashid
Messages: 3
Registered: March 2007
Location: Faisalabad

Junior Member

Hello,

How i can select/sort rows from an existing table (more than a million rows) in natural order. (The exact order in which rows are inserted)
waiting for an immediate response.

Thank you.

Report message to a moderator

Re: Select/sort rows from a table in "insertion" order. [message #225759 is a reply to message #225729]

Wed, 21 March 2007 05:27

Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If this table doesn't contain a column which holds information about insertion order (for example, a sequence-populated column or a DATE (including time portion) column), as far as I can tell - no, you can not know in which order records have been inserted into a table.

Report message to a moderator

Re: Select/sort rows from a table in "insertion" order. [message #225965 is a reply to message #225759]

Thu, 22 March 2007 02:08

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

@LF this is a general problem I think Oracle should make a compulsory field with every row. Then this problem will be solved.
Ashu

Report message to a moderator

Re: Select/sort rows from a table in "insertion" order. [message #226963 is a reply to message #225965]

Tue, 27 March 2007 00:34

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Did you raise an enhancement request on Metalink for this?
(posting suggestions on a forum is usually not the fastest way to get functionality added... Wink

Report message to a moderator

Previous Topic:	discoverer on solaris
Next Topic:	REP-1849

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 08 05:59:25 CST 2024