set pagesize 200 colsep ' ' col Owner format a20 col Object_Name format a30 col Last_DDL format a20 break on Owner select Owner, Object_type Object_Name, Timestamp Last_DDL from DBA_OBJECTS where SysDate - TO_DATE(TimeStamp,'YYYY-MM-DD:HH24:MI:SS') < 1 order by Owner, Object_Name /
The following two tabs change content below.