9xqlbw
Last Updated: February 25, 2016
·
719
· bielversallini
B84a20bc53d762f757c8157b3b02fdba

PL/SQL: Cursors with Parameters

PROCEDURE example

  CURSOR emp_cur (emp_id_in NUMBER := 0) IS
    SELECT employee_id, emp_name
     FROM employee
     WHERE employee_id = emp_id_in;

BEGIN

  OPEN emp_cur (1001);

END example;
Say Thanks
Respond