SQL-Oracle預存程序-迴圈A表，向B表插入資料

標籤：

--預存程序，查詢A表，向B表插入資料create or replace procedure prc_sg_sjtj_config(p_flag out varchar2) ISBEGIN  FOR c_row IN (SELECT T.UNIT_NAME,                       T.DATA_NAME,                       T.TABLE_NAME,                       T.UPDATE_ODR,                       DECODE(T.DATA_METHODS,                              ‘檔案‘,                              ‘拷貝‘,                              ‘介面‘,                              ‘服務介面‘,                              ‘交換平台‘) AS DATA_METHODS                  FROM v_dataservice_ext t                 where t.data_type = ‘0‘                   AND T.DATA_NAME NOT IN (SELECT s.msxx FROM t_sg_sjdjtj s)) LOOP      INSERT INTO t_sg_sjdjtj      (ywdw, ywb, msxx, ms, djfs, tjbz)    VALUES      (c_row.unit_name,       c_row.table_name,       c_row.data_name,       c_row.UPDATE_ODR,       c_row.DATA_METHODS,       ‘1‘);    COMMIT;  END LOOP;  p_flag := ‘1‘;END prc_sg_sjtj_config;

 

SQL-Oracle預存程序-迴圈A表，向B表插入資料