CREATE OR REPLACE PROCEDURE Test_Pro
AS
sqlstr varchar2(200);BEGIN FOR i IN( SELECT DISTINCT (TO_CHAR (TestDate, 'yymm')) AS yymm
FROM TABLEA
WHERE TestDate > TO_DATE ('200301', 'yyyymm'))
LOOP
select TO_CHAR (SYSDATE, 'YYYYMMDD') into opDate from dual;
sqlstr := 'INSERT INTO TABLE_B (COL1,COL2,COL3'||
'SELECT COL11,COLL22,COLL33 FROM TABLEC_' ||
i.yymm||
'@NGOSS';
EXECUTE IMMEDIATE v_sql;
END LOOP;EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
END;这个存储过程中的i.yymm和@NGOSS ,当中"." 和 "@'的用法,尤其是'@'的用法请叙述的尽可能详细一些,多谢多谢!
AS
sqlstr varchar2(200);BEGIN FOR i IN( SELECT DISTINCT (TO_CHAR (TestDate, 'yymm')) AS yymm
FROM TABLEA
WHERE TestDate > TO_DATE ('200301', 'yyyymm'))
LOOP
select TO_CHAR (SYSDATE, 'YYYYMMDD') into opDate from dual;
sqlstr := 'INSERT INTO TABLE_B (COL1,COL2,COL3'||
'SELECT COL11,COLL22,COLL33 FROM TABLEC_' ||
i.yymm||
'@NGOSS';
EXECUTE IMMEDIATE v_sql;
END LOOP;EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
END;这个存储过程中的i.yymm和@NGOSS ,当中"." 和 "@'的用法,尤其是'@'的用法请叙述的尽可能详细一些,多谢多谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货