Example:-
DECLARE
TYPE EMPRECTYPE IS RECORD (LAST_NAME EMPLOYEES.LAST_NAME%TYPE,
SALARY EMPLOYEES.SALARY%TYPE);
EMPREC EMPRECTYPE;
CURSOR EMPCUR IS SELECT LAST_NAME,SALARY FROM EMPLOYEES;
BEGIN
IF NOT EMPCUR%ISOPEN THEN
...
Tuesday, May 22, 2018
Thursday, May 3, 2018
Cursor with parameters in Plsql / PL/SQL Parameterized Cursor
Cursor with parameters
we can declare cursors with parameters.
Parameterized cursors are also saying static cursors that can passed parameter value when cursor are opened.
Syntax
The syntax for a cursor with parameters in Oracle/PLSQL is:
CURSOR cursor_name (parameter_list)
IS
SELECT_statement;
Example
For example, you could define...