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

what is the difference between sql and t-sql? : Transact sql

811

Explain the select statement in sql?

825

What is self-join and what is the requirement of self-join?

843

What is the difference between python and sql?

709

Can we alter stored procedure?

717

what are the differences between char and varchar? : Sql dba

748

What is trigger types in sql?

722

How does cross join work in sql?

706

What are sql triggers used for?

722

how can we optimize or increase the speed of a mysql select query? : Sql dba

689

What are the benefits of stored procedures?

709

Can we use the cursor's to create the collection in PL/SQL?

701

What normalization means?

710

Which join is like an inner join?

720

How to create your own reports in sql developer?

729