| Qry Help Plz [message #9227] |
Tue, 28 October 2003 02:17  |
Cindreen Clarence
Messages: 41
Registered: March 2003
Location: Bangalore
|
Member |
|
|
Hi All,
How can i see the list of tables which have been created on SYSDATE using the data dictionaries?
Thanx
|
|
|
|
| Re: Qry Help Plz [message #9232 is a reply to message #9227] |
Tue, 28 October 2003 03:50  |
Rajarshi Dasgupta
Messages: 52
Registered: October 2001
|
Member |
|
|
You can not use only SYSDATE as SYSDATE contains stores time upto milliseconds. So, you have to check only the date part of it. Here's the SQL
Select * From user_objects
Where object_type = 'TABLE'
And to_char(created, 'yyyymmdd') = to_char(Sysdate, 'yyyymmdd')
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
