Can i possible to see Table Details ?
Ex :
Table Name Date Time User
Emp May/18/2010 12:59pm Scott
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
what are ddl statements in mysql? : Sql dba
what is sql server agent? : Sql dba
What is a REF CURSOR? Compare strong and week ref cursor types.
What has stored procedures in sql?
What is the difference between inner join and outer join?
what is 'mysqldump'? : Sql dba
Explain the steps needed to create the scheduled job?
What is a rank in sql?
How do you respond to dementia behavior?
What is difference between joins and union?
Define tables and fields in a database
What is the difference between the conventional and direct path loads? : aql loader