sum(decode(t.OBJECT_TYPE, 'TABLE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'TRIGGER', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'INDEX', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'VIEW', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'SEQUENCE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'PROCEDURE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'FUNCTION', 1,0)) ,
v_job_num,
sum(decode(t.OBJECT_TYPE, 'PACKAGE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'PACKAGE BODY', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'INDEX PARTITION', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'TABLE SUBPARTITION', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'TABLE PARTITION', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'INDEX SUBPARTITION', 1,0)) ,
sysdate
from user_objects t ;
commit;
exception
when others then
v_errcode := sqlcode;
v_errmsg := substr(sqlerrm, 1, 200);
dbms_output.put_line(v_errcode || ':' || v_errmsg);
end;
sum(decode(t.OBJECT_TYPE, 'TRIGGER', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'INDEX', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'VIEW', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'SEQUENCE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'PROCEDURE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'FUNCTION', 1,0)) ,
v_job_num,
sum(decode(t.OBJECT_TYPE, 'PACKAGE', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'PACKAGE BODY', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'INDEX PARTITION', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'TABLE SUBPARTITION', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'TABLE PARTITION', 1,0)) ,
sum(decode(t.OBJECT_TYPE, 'INDEX SUBPARTITION', 1,0)) ,
sysdate
from user_objects t ;
commit;
exception
when others then
v_errcode := sqlcode;
v_errmsg := substr(sqlerrm, 1, 200);
dbms_output.put_line(v_errcode || ':' || v_errmsg);
end;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-1061421/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
