PLSQL Language Referenc-PL/SQL靜態SQL-靜態SQL的描述-游標-顯式游標

--顯式游標的宣告

CURSOR cursor_name [ parameter_list ] RETURN return_type;

--顯式游標的定義

CURSOR cursor_name [ parameter_list ] [ RETURN return_type ]

IS select_statement;

DECLARE

    CURSOR c1 RETURN departments%ROWTYPE;    -- 宣告c1

    -- 宣告加定義c2

    CURSOR c2 IS                            

    SELECT employee_id, job_id, salary FROM employees

    WHERE salary > 2000;

    -- 定義 c1,重複返回型別

    CURSOR c1 RETURN departments%ROWTYPE IS 

        SELECT * FROM departments             

        WHERE department_id = 110;

    -- 宣告 c3

    CURSOR c3 RETURN locations%ROWTYPE;     

    -- 定義 c3, 省略返回型別

    CURSOR c3 IS                            

        SELECT * FROM locations               

        WHERE country_id = 'JP';

BEGIN

    NULL;

END;