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
5024 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 inner join in sql?

578

How would you convert date into julian date format?

586

what is commit? : Sql dba

608

what is table? : Sql dba

568

what is 'mysqld'? : Sql dba

534

Is inner join faster than left join?

623

what are the features and advantages of object-oriented programming? : Sql dba

536

What is the purpose of using pl/sql?

653

What is a sql driver?

521

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

522

What are the different types of dbms?

543

What is a record in a database?

553

How do I run a program in pl sql?

491

how to include character strings in sql statements? : Sql dba

544

explain the delete statements in sql

574