Definition and Application of pl SQL with parameter cursor, pl cursor

Definition and Application of pl SQL with parameter cursor, pl cursor
CURSOR cursor_name (parameter_name datatype) IS select_statement; -- only the type can be specified and the specific size cannot be specified.
OPEN cursor_name (parameter value );
FECTH cursor_name INTO variable ,...;

CLOSE cursor_name;

1. Declare
2. Cursor emp_cursor (v_depnto number) is select ename, sal from scott. emp where deptno = v_depnto order by empno;
3. Emp_record emp_cursor % rowtype;
4. V_dno number;
5. Begin
6. V_dno: = & no;
7. If not emp_cursor % isopen then
8. Open emp_cursor (v_dno );
9. End if;
10. Null;
11. Loop
12. Fetch emp_cursor into emp_record;
13. Exit when emp_cursor % notfound;
14. Dbms_output.put_line ('name: '| emp_record.ename |', salary: '| emp_record.sal );
15. End loop;
16. Null;
17. If emp_cursor % isopen then
18. Close emp_cursor;
19. End if;
20. End;