SELECT OBJECT_NAME,
TO_CHAR(CREATED, 'DD-Mon-RR HH24:MI') CREATE_TIME,
TO_CHAR(LAST_DDL_TIME, 'DD-Mon-RR HH24:MI') MOD_TIME,
STATUS
FROM USER_OBJECTS
WHERE SYSDATE - LAST_DDL_TIME < 7
Tuesday, July 14, 2009
Get objects created/modified recently
at 6:32 AM
Labels: Oracle, Oracle Query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment