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

4 Answers
7125 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2057

How to get the Installed Oracle Version Information ?

1191

What is a proxy object?

1109

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2266

How to export several tables together?

1106

What are the differences between char and varchar2 in oracle?

1249

How to select an oracle system id (sid)?

1123

WHAT IS ecc 6.0

2205

How many types of auditing in Oracle?

1088

How to get last row id?

1058

How to use "in" parameter properly?

1120

How to check database size in Oracle?

1257

What is oracle sid?

1006

What is the minimum client footprint required to connect c# to an oracle database?

1162

What is a snapshot log?

1051