在存储过程中,
BEGIN
FOR REC IN(SELECT * FROM table_name)
LOOP
SQL_TEXT:='INSERT INTO table_name
(column1,c2,c3....)
select '||param1||','||REC.column||',''常量''
from table_name
WHERE ...';
EXECUTE IMMEDIATE SQL_TEXT;COMMIT;
END LOOP;
END;
在sql查询中
BEGIN
FOR REC IN(SELECT * FROM table_name)
LOOP
EXECUTE IMMEDIATE'INSERT INTO table_name
(column1,c2,c3....)
select '||param1||','||REC.column||',''常量''
from table_name
WHERE ...';
COMMIT;
END LOOP;
END;