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;
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