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;
Ad Choices