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

‘Order by’ is not allowed in a view how can you sort information from a view?

1085

What number sorts of privileges are accessible in sql?

1037

What is a natural primary key?

1051

What is a mutating table error and how can you get around it?

1051

What is the architecture of ms sql reporting service?

985

What are the types of dml?

981

Explain the difference between functions and stored procedures in sql server?

978

Explain partitioned view?

1080

How to convert numeric values to integers in ms sql server?

1093

How to use union to merge outputs from two queries together in ms sql server?

1069

How many columns can we include on clustered index ?

990

can any body tell me how to know the password of current user in sql server

2072

What is the recovery model?

992

How to find table changes in sql server?

1123

Explain boyce and codd normal form(bcnf)?

958