cuiyan6838的博客

oracle concepts http://www.cuug.com/ora4-1.html http://www.cuug.com/jishushalong/shipinkecheng/QQ...

oracle concepts http://www.cuug.com/ora4-1.html http://www.cuug.com/jishushalong/shipinkecheng/QQ...

/** @description Unknown Errors occurs during the whole create and drop process*/ exception when oth...

end if; dbms_output.put_line('7'||vv_add_p_sql); /** @description update process...

dbms_output.put_line('6'||vv_add_p_sql); /** @description update process flag*/ ...

dbms_output.put_line('3'||vv_add_p_sql); elsif upper(l_table_list.partition_type_id) = 'R' th...

vv_etl_d := to_char(add_months(vd_deal_date, 0 - l_table_list.partition_count),'yyyymm'); vv_etl_...

vv_etl_a varchar2(250) ; --add partition date/week/month vv_etl_d varchar2(250) ;...

begin /** * @description initialize variable * @field-mapping vd_begin_date = (sysdate) ...

vi_task_id integer; --task log id vv_procedure_name varchar2(30); ...

comment on column TB_SYS_TAB_PARTITIONS.compression is '该分区是否压缩.0:不压缩,1:压缩';comment on column TB_SYS_TAB_PART...

---使用方法：1、创建相关的表和过程；-- 2、将现场的分区表填写到分区控制表中（具体的可以根据字段备注进行，有问题可以联系我）-- 3、测试成功之后，将过程添加到调度中，每天凌...

sum(decode(t.OBJECT_TYPE, 'TABLE', 1,0)) , sum(decode(t.OBJECT_TYPE, 'TRIGGER', 1,0)) , ...

create or replace procedure p_obj_statas v_id number; v_job_num number; v_errcode n...

create or replace procedure substring_array2(str in varchar2) as type array_str is table of varchar2(100) index...

create or replace procedure substring_array(name varchar2, ny varch...

create table T_OBJ_TOTAL( T_ID NUMBER, T_TABLE NUMBER, T_TRIGGER ...

create or replace procedure p_meger asbegin MERGE INTO t_login_info_bak a USING t_login_info b ON (a.ti...

create or replace procedure p_insert(num in int) as v_errcode number; v_errmsg varchar2(200); t1 num...

create or replace procedure p_dny_sql(i_job varchar2,o_res OUT varchar2)as v_str varchar2(2000); v_name...