Updates

    Script to find out if any new table/procedure added in the schema in past 24 hours

    set serveroutput on
    declare
    v varchar2(2000);
    begin
         for i in (select object_name,object_type from dba_objects where to_date(created,'yy-mm-dd') >= to_date(sysdate-1,'yy-mm-dd') and owner = 'USER')
    loop

    select dbms_metadata.get_ddl(i.object_type,i.object_name,'USER') into v from dual;
    dbms_output.put_line(v);
    end loop;
    end;

    0 comments:

    Post a Comment

    Copyright © ORACLE ONLINE DBA
    Developed By Pavan Yennampelli