SELECT TO_CHAR(LAST_ANALYZED,'DD-MON-YYYY HH12:MI:SS'),COLUMN

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

Question Posted / ajit nayak

Answer Posted / ajit nayak

SELECT TO_CHAR(LAST_ANALYZED,'DD-MON-YYYY HH12:MI:SS'),COLUMN_NAME
FROM COLS
WHERE TABLE_NAME = 'EMP';

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you store pictures in a database?

947

Can you drop an index associated with a unique or primary key constraint?

964

What is the usage of merge statement?

1094

What is rowid and rownum in oracle?

951

What is bulk copy or bcp in oracle?

1042

How to use subqueries with the in operator using oracle?

1029

Difference between inner join vs where ?

976

How to select some columns from a table in oracle?

1001

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1993

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

How to create an oracle testing table?

1005

How to unlock the sample user account in oracle?

915

What are the major difference between truncate and delete?

976

What is a user role in oracle?

1063

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1287