last_ddl_time format

February 3, 2010 at 05:25:42
Specs: Windows XP
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?

See More: last_ddl_time format

Report •

#1
February 5, 2010 at 15:59:08
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;


Report •
Related Solutions


Ask Question