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 may join possible between (requisition with purchase order)

2230

Is there an oracle sql query that aggregates multiple rows into one row?

961

How to sort the query output in oracle?

1006

Can group functions be mixed with non-group selection fields?

1008

Can objects of the same schema reside in different tablespace?

1044

State and explain the different types of data models?

924

What is the difference between alert log file and tarce file ?

2148

Why is oracle used?

920

What is a named program unit?

1048

How to insert multiple rows with one insert statement in oracle?

1056

How to create additional tablespaces for an new database?

1008

How translate command is different from replace?

1059

Why cursor variables are easier to use than cursors?

1065

how to do daily transactions with out sql* loader control file regesterd in apps?

1665

What happens if you set the sga too low in oracle?

1117