OraFAQ Forum: Server Administration » Very Interesting Question

Home » RDBMS Server » Server Administration » Very Interesting Question

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

Very Interesting Question [message #373936]

Thu, 17 May 2001 10:12

sriram
Messages: 58
Registered: September 2000

Member

Hi everybody,
i have a question to ask:
"How do I find out the oldest record in a Oracle table"
By oldest , i mean , the first inserted record.
Please feel free to contact me at sriram22@123india.com
Regards
Sriram

Report message to a moderator

Re: Very Interesting Question [message #373942 is a reply to message #373936]

Thu, 17 May 2001 14:33

sverch
Messages: 582
Registered: December 2000

Senior Member

select emplid, rownum from your_table where rownum in (select min(rownum) from your_table);

Report message to a moderator

Re: Very Interesting Question [message #373943 is a reply to message #373936]

Thu, 17 May 2001 14:57

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

The lowest value rownum does not garantee that it was the first record inserted into the table.

Report message to a moderator

Re: Very Interesting Question [message #373952 is a reply to message #373936]

Thu, 17 May 2001 22:21

sriram
Messages: 58
Registered: September 2000

Member

Hi sverch,
Thanks for the answer.
That's fine. Your solution inherently
makes a correct assumption that "Oracle retrieves the data in the way it has been inserted"
(true when select is used without any sorting)
But, what i actually meant by my query is that,
whether ORACLE maintains any time stamp of data insertion internally..??
Please give a thought on this.

Thanks & Regards
Sriram

Report message to a moderator