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

Explain the use of owner option in exp command.

1003

How to retrieve data from an explicit cursor?

1018

What happens in oracle commit?

977

What are the types of trigger in oracle?

933

Why oracle is used?

1010

Give the various exception types.

954

How to create an oracle database?

984

What happens to the current transaction if a ddl statement is executed?

965

How to delete a user account in oracle?

925

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3163

How do I start tns listener?

997

Is oracle a programming language?

949

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2194

Why do we use bulk collect in oracle?

1021

How to run create database statement again?

1092