select table_name from user_tables where last

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

Question Posted / manoj

Answer Posted / manoj

select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Write query to return all rows sql?

1004

What are data driven subscriptions?

106

What is a covered index?

890

Do you know what is rank function?

1028

How raid can influence database performance?

969

Which sql server table is used to hold the stored procedure scripts?

1024

We need to perform what steps in the following order to work with a cursor?

1168

What are a scheduled jobs or what is a scheduled tasks?

848

What is difference between count (*) and count 1?

865

What is indexing a document?

968

please differentiate between delete and truncate?

941

What are pessimistic lock and optimistic lock?

997

What is the use of group by clause?

899

Tell me about pre-defined functions of sql?

1071

What is local temp table?

895