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
7017 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

What is Reduced List of Values?

2172

what is dynamic SGA and static SGA

4421

How to loop through data rows in the implicit cursor?

1079

How to drop a stored function?

1140

What is the oracle implicit cursor?

1068

How to convert a date to char in oracle? Give one example.

1072

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2468

Please explain oracle data types with examples?

1075

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1929

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2502

How oracle handles dead locks?

1070

How to fetch the row which has the max value for a column?

1002

How to define a data source name (dsn) in odbc manager?

1036

What are set operators?

1089

How to write date and time interval literals in oracle?

1036