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;

Related protips

Have a fresh tip? Share with Coderwall community!