WHEN OTHERS THEN times:=times+1; if times<100 then -- dbms_output.put_line('times:'||times); rename_table(source_name1,target_name1,times); else dbms_output.put_line(SQLERRM); dbms_output.put_line('error over 100 times,exit'); end if; end; / 截断分割log表的存储过程log_history:...
times in out number) is query_str varchar2(4000); source_name1 varchar2(64); target_name1 varchar2(64); cursor c1 is select segment_name from user_segments where segment_name=upper(source_name); dummy c1%rowtype; cursor c2 is select segment_name from user_segments where segment_...
正在翻译,请等待... 翻译结果3复制译文编辑译文朗读译文返回顶部 Take the surface area within this product 600cm2 respectively (split growth 5cm, w 0.3cm small piece) in three reset 500ml cone-shaped bottle 翻译结果4复制译文编辑译文朗读译文返回顶部 ...
dbms_output.put_line('error over 100 times,exit'); end if; end; / 截断分割log表的存储过程log_history: create or replace procedure log_history is query_str varchar2(32767); year_month varchar2(8); times number; begin select to_char(sysdate-15,'YYYYMMDD') into year_month from dual; ...
times number; begin select to_char(sysdate-15,'YYYYMM') into year_month from dual; times:=0; query_str :='create table log_new pctfree 10 pctused 80 as select * from log where 1=2'; execute immediate query_str; query_str :='alter table log_new add constraints log_'||year_month...