select b.name, a.analyzetime from tab$ a, obj$ b where a.obj#=b.obj# and

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

Question Posted / aseem k

Answer Posted / aseem k

select b.name, a.analyzetime from tab$ a, obj$ b
where a.obj#=b.obj#
and b.name ='EMP'

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between data migration and production migration.

2401

What is merge statement used for?

1076

How many memory layers are in the oracle shared pool?

1256

How can we create the complete backup of data in the oracle.

2202

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2602

List the types of joins used in writing subqueries?

1038

How to write a query with an inner join in oracle?

1097

How do I uninstall oracle client from windows?

1060

Can we write dml statement in function in oracle?

1126

How to display employee records who gets more salary than the average salary in the department?

1127

How to save query output to a local file?

1088

What is primefaces used for?

1098

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

2104

11. Display the client number and name and the client number and name of the person who referred that client.

2391

What are the numeric comparison operations?

1168