Home » RDBMS Server » Server Administration » Is it Possible?
Is it Possible? [message #59621] Tue, 09 December 2003 04:05 Go to next message
JoinNepal
Messages: 33
Registered: October 2003
Member
Hi,
is it possible to retrieve the data on the basis of the system date sorting?
I want to filter the data from the different tables on the basis of Sysdate..............
Point: I don't have any date column which can define the data entered date in my table...
Hope to Hear from you soon..
yours,
joinnepal
Re: Is it Possible? [message #59628 is a reply to message #59621] Tue, 09 December 2003 20:59 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
No, IMHO it is not possible without any date column to sort by. A part of the relational paradigm is that data is stored in no particular order. Even ROWID can't help you out.

Perhaps someone else has another opinion/solution...
MHE
Previous Topic: DBMS_UTILITY AND DBMS_STATS IN ORACLE 8i
Next Topic: Pmon
Goto Forum:
  


Current Time: Fri Sep 20 08:19:58 CDT 2024