SELECT OWNER,OBJECT_NAME,To_char(CREATED,'MON//DD/YYYY'), to

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

Question Posted / saraswathi muthuraman

3 Answers
5993 Views
I also Faced
E-Mail Answers

Answer Posted / saraswathi muthuraman

SELECT OWNER,OBJECT_NAME,To_char(CREATED,'MON//DD/YYYY'),
to_char(CREATED,'HH:MM PM') from ALL_OBJECTS WHERE
OBJECT_TYPE ='TABLE' AND OBJECT_NAME ='EMP_TEST';

Result:

Saras EMP_TEST
JUN//01/2010 11:06 AM

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is a foreign key always unique?

884

What are the differences between implicit and explicit cursors?

1004

What is procedure in pl sql?

980

Explain the methods used to protect source code of pl/sql.

965

Explain two easy sql optimizations.

962

How run sql*plus commands that are stored in a local file?

976

how to enter binary numbers in sql statements? : Sql dba

923

Can there be more than one function with a similar name in a pl/sql block?

927

What is sql scripting?

1037

Is time a data type in sql?

853

What does data normalization mean?

900

What is auto increment feature in sql?

1068

What is an alias command?

1007

What are secondary keys?

923

How many unique keys can a table have?

959