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

What is a memo field?

1015

how is myisam table stored? : Sql dba

1097

difference between anonymous blocks and sub-programs.

1188

What is consistency?

1187

what is a composite primary key ? : Sql dba

1093

What will you get by the cursor attribute sql%notfound?

1129

What are the sql commands?

1229

what tools available for managing mysql server? : Sql dba

1130

What is sql keyword?

1043

How do we accept inputs from user during runtime?

1117

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3107

What are the syntax and use of the coalesce function?

1273

What are the basic sql commands?

1139

Does truncate require commit?

1032

What are functions in sql?

995