DECLARE
-- 变量定义
FROM TABLE_NAME;
BEGIN
OPEN table_cur ;
FETCH table_cur INTO sz_column1 , sz_column2;
LOOP
EXIT WHEN NOT table_cur %FOUND;
SELECT count(*) INTO i_count_1 FROM TABLE_NAME2; -- 取判断条件
IF i_count_1 > 0 THEN
DO SOMETHING; -- 执行语句
END IF;
FETCH table_cur INTO sz_column1 , sz_column2;
END LOOP;
CLOSE table_cur ;
END;
/
COMMIT;
-- 变量定义
sz_column1 varchar2(32);
sz_column2 varchar2(32);
-- 创建游标
CURSOR table_cur IS
SELECT column1,column2FROM TABLE_NAME;
BEGIN
OPEN table_cur ;
FETCH table_cur INTO sz_column1 , sz_column2;
LOOP
EXIT WHEN NOT table_cur %FOUND;
SELECT count(*) INTO i_count_1 FROM TABLE_NAME2; -- 取判断条件
IF i_count_1 > 0 THEN
DO SOMETHING; -- 执行语句
ELSE
DO SOMETHING OR RAISE_APPLICATION_ERROR(-20031, '给出错误提示!' || SQLERRM); -- 执行语句
-- EXIT; -- 退出程序END IF;
FETCH table_cur INTO sz_column1 , sz_column2;
END LOOP;
CLOSE table_cur ;
END;
/
COMMIT;