qq_16240463的博客

通过四层循环将查询的数据用来更新目标表减少手工任务量 CREATE OR REPLACE PROCEDURE P_LOOP_TEMP AS V_PRO_NAME VARCHAR2(500); V_PRO_NAME_2 VARCHAR2(500); CURSOR CUR IS SELECT DISTINCT a.过程名 FROM TEMP_210402 a WHERE a.任务名称 IS NULL; BEGIN OPEN CUR; LOOP FETCH CUR INTO V_PRO_NA...