| shahul |
Posted: Sep 27, 2007 11:00:13 AM |
Total Post: 17
Joined: Sep, 2007
|
| Hi can you any one please tell me how to know the table creation time. |
|
|
 Mohammed Taj |
| Posted: Sep 27, 2007 12:40:09 PM |  |
|
Total Post: 694
Joined: Jul, 2007
|
alter session set nls_date_format = 'dd-mon-yyyy hh23:mi:ss';
select created from user_objects where object_type = 'TABLE' and object_name = 'TABLE_NAME';
Regards
Mohammed Taj
|
|
|
|
|
| shahul |
| Posted: Sep 28, 2007 05:39:15 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
|
|
|
|
| mani |
| Posted: Sep 29, 2007 09:37:28 PM | |
|
Total Post: 2
Joined: Sep, 2007
|
Small correction :
Date format should be 24Hrs not 23.
alter session set nls_date_format = 'dd-mon-yyyy hh24:mi:ss';
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
