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

3 Answers
6219 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

describe mysql connection using mysql binary. : Sql dba

1064

What is pl sql architecture?

959

what is a database transaction? : Sql dba

1178

What is sql and also describe types of sql statements?

1066

What is Collation Sensitivity ? What are the various type ?

952

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1107

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2082

What is scope of pl sql developer in future?

1018

Is primary key clustered index?

947

what is the difference between clustered and non clustered index in sql? : Sql dba

1124

How to convert comma separated string to array in pl/sql?

1180

how do you know the version of your mysql server? : Sql dba

1002

What are the usages of sql?

1056

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

1084

What is sqlca in db2?

959