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

How to find the duplicate rows count from employees table in oracle?

1041

List out the difference between commit, rollback, and savepoint?

987

What is rowid and rownum in oracle?

955

What are the data types in oracle?

982

How to list all indexes in your schema?

1034

How to update values on multiple rows in oracle?

975

How to set up autotrace for a user account?

976

what is IDE,DMV in sql server?

2754

What is merge in oracle?

997

How to specify default values in insert statement using oracle?

1038

Use of an integrity constraint is better to validate data. Explain

979

What is an oracle table?

934

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1814

How much memory your 10g xe server is using?

1051

What are the ways tablespaces can be managed and how do they differ?

2274