SELECT OWNER,OBJECT_NAME,TRUNC(CREATED),TIMESTAMP FROM DBA

Can i possible to see Table Details ?
Ex :
Table Name Date Time User
Emp May/18/2010 12:59pm Scott

Question Posted / kamal

Answer Posted / kamal

SELECT OWNER,OBJECT_NAME,TRUNC(CREATED),TIMESTAMP FROM
DBA_OBJECTS WHERE OBJECT_TYPE ='TABLE' AND OBJECT_NAME
='EMP'

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which software is used for pl sql programming?

524

What is using in sql?

568

What is varchar sql?

620

How to select unique records from a table?

571

how can you create an empty table from an existing table? : Sql dba

663

What is union and union all keyword in sql?

568

How do you remove duplicate records from a table?

511

What is difference between table and view?

527

What are the two types of periodical indexes?

507

Is sql a backend?

551

what is a trigger? : Sql dba

580

What operating systems are supported by oracle sql developer?

522

What is query execution plan in sql?

571

What is a null value?

659

What is pl sql architecture?

504