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;
select count(*) into v_job_num from user_jobs;
insert into t_obj_total(
T_ID,
T_TABLE,
T_TRIGGER,
T_INDEX,
T_VIEW,
T_SEQUENCE,
T_PROCEDURE,
T_FUNCTION,
T_DBMS_JOB,
T_PACKAGE,
T_PACKAGE_BODY,
T_INDEX_PARTITION,
T_TABLE_SUBPARTITION,
T_TABLE_PARTITION,
T_INDEX_SUBPARTITION,
STAT_TIME
)
select v_id,
as
v_id number;
v_job_num number;
v_errcode number;
v_errmsg varchar2(200);
begin
v_id := seq_obj_total.nextval;
select count(*) into v_job_num from user_jobs;
insert into t_obj_total(
T_ID,
T_TABLE,
T_TRIGGER,
T_INDEX,
T_VIEW,
T_SEQUENCE,
T_PROCEDURE,
T_FUNCTION,
T_DBMS_JOB,
T_PACKAGE,
T_PACKAGE_BODY,
T_INDEX_PARTITION,
T_TABLE_SUBPARTITION,
T_TABLE_PARTITION,
T_INDEX_SUBPARTITION,
STAT_TIME
)
select v_id,
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-1061419/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
