📄 5.15.txt
字号:
DECLARE
CURSOR emp_cursor IS SELECT departmentno FROM employee FOR UPDATE;
v_deptno employee.departmentno%TYPE;
BEGIN
OPEN emp_cursor;
LOOP
FETCH emp_cursor INTO v_deptno;
EXIT WHEN emp_cursor%NOTFOUND;
IF v_deptno='003' THEN
DELETE FROM employee WHERE CURRENT OF emp_cursor;
END IF;
END LOOP;
CLOSE emp_cursor;
END;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -