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

4 Answers
7119 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is truncate autocommit in oracle?

1147

Explain implicit cursor.

1074

How do you find current date and time in oracle?

1099

Why do we need oracle client?

1006

Can you create a synonym without having a table?

1090

What is an anonymous block?

1323

How to define a sub function?

1198

Explain what are the uses of rollback segment?

1065

What is raw datatype?

1185

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1991

How to delete multiple rows from a table in oracle?

1112

How many types of cluster table in Oracle?

1079

How to best split csv strings in oracle 9i?

1094

What privilege is needed for a user to query tables in another schema?

1029

Difference between oracle's plus (+) notation and ansi join notation?

1160