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

6. Display the client name and order date for all orders using the traditional method.

1747

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1874

What is a database table in oracle?

570

Explain oracle 12c new features for developers?

536

What is Data Dictionary Cache in Oracle?

657

What is a dead lock in oracle?

587

When do you get a .pll extension in oracle?

673

How to retrieve data from an cursor to a record?

559

how to make an oracle object

1854

Point the difference between translate and replace?

568

What are the logical operations?

673

How many types of tables are there in oracle?

572

How to define an external table with a text file?

577

Explain mutating triggers.

569

What are the roles of dba?

610