----循环方法---
BEGIN
--(查询结果集循环)--
for item in (SELECT
para_id,
mod_code,
para_code,
para_name,
para_value,
para_type,
para_option,
data_type,
DESCRIBE,
b.comp_code,
b.copy_code
FROM
sys_para a,
sys_copy b
WHERE b.is_main = 1 AND a.mod_code = '09' AND para_code = '0901' ) LOOP
-- 将查询到的数据赋值给变量 --
INSERT INTO sys_para_data ( para_id, mod_code, para_code, para_name, para_value, para_type, para_option, data_type, DESCRIBE, comp_code, copy_code )
VALUES
( (select max(para_id)+1 from SYS_PARA_DATA), item.mod_code, item.para_code, item.para_name, item.para_value, item.para_type, item.para_option, item.data_type,
item.DESCRIBE, item.comp_code, item.copy_code );
END LOOP;
END;