set pages 50
set lines 140
col owner heading 'Owner' format
a15
col object_name heading 'Object' format a30
col object_type heading
'Type' format a15
col last_ddl heading 'Changed' format a15
select
owner,
object_name,
object_type,
to_char(last_ddl_time,'dd-mon-yy hh24:mi') last_ddl
from
dba_objects
where owner not in ('SYS','SYSTEM')
and
trunc(last_ddl_time) >= trunc(sysdate-1) and trunc(last_ddl_time) <
trunc(sysdate)
/
No comments:
Post a Comment