select scn_to_timestamp(max(ora

How to find the date and time of last updated table?

Question Posted / siddharthapenchala

6 Answers
9742 Views
Teledata, I also Faced
E-Mail Answers

Answer Posted / siddharthapenchala

select scn_to_timestamp(max(ora_rowscn)) from <TN>

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I edit a stored procedure in sql server?

930

why would you use sql agent? : Sql server database administration

1221

what are the different types of replication you can set up in sql server? : Sql server database administration

1031

System requirements for sql server 2005 express edition?

1035

How to identify current user in ssrs report?

405

What does normalization do to data?

1079

How can you append an identity column to a temporary table?

957

What is transact-sql ddl trigger?

1113

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1948

What is order of B+tree?

1109

last function used in MS Access to convert sql what function will use in sql

2078

What is primary key index?

985

Differentiate between a primary key and a unique key.

1076

How to create nested stored procedure?

1026

What is an index in a database?

983