create table T_OBJ_TOTAL
(
T_ID NUMBER,
T_TABLE NUMBER,
T_TRIGGER NUMBER,
T_INDEX NUMBER,
T_VIEW NUMBER,
T_SEQUENCE NUMBER,
T_PROCEDURE NUMBER,
T_FUNCTION NUMBER,
T_DBMS_JOB NUMBER,
T_PACKAGE NUMBER,
T_PACKAGE_BODY NUMBER,
T_INDEX_PARTITION NUMBER,
T_TABLE_SUBPARTITION NUMBER,
T_TABLE_PARTITION NUMBER,
T_INDEX_SUBPARTITION NUMBER,
STAT_TIME DATE
)
create or replace procedure p_obj_stat
as
v_id number;
v_job_num number;
v_errcode number;
v_errmsg varchar2(200);
begin
v_id := seq_obj_total.nextval;
(
T_ID NUMBER,
T_TABLE NUMBER,
T_TRIGGER NUMBER,
T_INDEX NUMBER,
T_VIEW NUMBER,
T_SEQUENCE NUMBER,
T_PROCEDURE NUMBER,
T_FUNCTION NUMBER,
T_DBMS_JOB NUMBER,
T_PACKAGE NUMBER,
T_PACKAGE_BODY NUMBER,
T_INDEX_PARTITION NUMBER,
T_TABLE_SUBPARTITION NUMBER,
T_TABLE_PARTITION NUMBER,
T_INDEX_SUBPARTITION NUMBER,
STAT_TIME DATE
)
create or replace procedure p_obj_stat
as
v_id number;
v_job_num number;
v_errcode number;
v_errmsg varchar2(200);
begin
v_id := seq_obj_total.nextval;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-1061416/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
