Skip to Main Content

Oracle Database Discussions

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!

how to check last updated record in a table

859486Aug 18 2011 — edited Aug 18 2011
i got a table called os_ondemand_logs.

schema name is osodlogs

i just want to know when the above table was updated.

i got below query which is not suitable to find excately can any one modify it please

thanks for help


select count(*) from os_ondemand_logs where log_time < to_date('05/05/2011','dd/MM/yyyy');
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2011
Added on Aug 18 2011
12 comments
15,352 views