Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sort records when there is no timestamp

752675May 11 2010 — edited May 12 2010
Hello All,
I'd like to know how we can do a sort based on timestamp on an oracle table when there is no timestamp column. I have a table

create table x_log (A varchar,B varchar,C varchar); /* note I do not have a timestamp col */

I'd like to know if its possible to find the records updated/inserted on an hourly basis for about a week's time. I do not have timestamp column here. Any help in this regard is greatly appreciated.

Thanks All.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2010
Added on May 11 2010
4 comments
1,067 views