Home » Developer & Programmer » Reports & Discoverer » Select/sort rows from a table in "insertion" order.
Select/sort rows from a table in "insertion" order. [message #225729] Wed, 21 March 2007 02:47 Go to next message
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.
Re: Select/sort rows from a table in "insertion" order. [message #225759 is a reply to message #225729] Wed, 21 March 2007 05:27 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Select/sort rows from a table in "insertion" order. [message #225965 is a reply to message #225759] Thu, 22 March 2007 02:08 Go to previous messageGo to next message
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
Re: Select/sort rows from a table in "insertion" order. [message #226963 is a reply to message #225965] Tue, 27 March 2007 00:34 Go to previous message
skooman
Messages: 912
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).
Previous Topic: discoverer on solaris
Next Topic: REP-1849
Goto Forum:
  


Current Time: Sat Dec 10 12:58:16 CST 2016

Total time taken to generate the page: 0.04210 seconds