Click here for important information about Computing.net.
i hav to query all_objects table where last_ddl_time='01 jan 2010'
but it refuses the input format...
Any body give me the exact format to query?
last_ddl_time http://www.google.com.au/#hl=en&q=l...
http://www.experts-exchange.com/Dat...
SELECT created, last_ddl_time, timestamp, object_name, subobject_name, object_type
FROM dba_objects
WHERE TRUNC(last_ddl_time) > '23-jul-2007'
ORDER BY last_ddl_time DESC;
| Yes (14) |  | |
| No (14) | | |
| I don't know (15) | |
Ad Choices