CURSOR cursor_name [ RETURN return_type ] IS select_statement;
CREATE OR REPLACE PROCEDURE P_6_6 AS
CURSOR c1 IS
SELECT employee_id, job_id, salary FROM employees WHERE salary > 2000;
CURSOR c2 RETURN departments%ROWTYPE IS
SELECT * FROM departments WHERE department_id = 110;
CURSOR c3 IS
SELECT * FROM departments WHERE department_id = 110;
BEGIN
NULL;
END;
GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 98 -