select table_name, to_char(last_analyzed, 'DD-MM-YY HH:MI:SS') f

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

Question Posted / manoj

Answer Posted / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

Is This Answer Correct ?

2 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

1005

What are the advantages of oracle?

1029

What are the different types of modules in oracle forms?

1002

Can we create database in oracle using command line ?

1092

How to get a list of all user accounts in the database?

1090

How do you find current date and time in oracle?

1051

What is the data type of dual table?

997

What is save point in oracle database?

1303

How to apply filtering criteria at group level in oracle?

1045

Is it possible to split the print reviewer into more than one region ?

2281

What are nested tables?

1178

How to convert character types to numeric types?

1139

What is oracle datasource?

993

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

How will you identify oracle database software release?

1016