RefCursor Bind Variables

Store select statements in the database and reference them from Sql*Plus. Note: To print again, the PL/Sql block must be executed again.

Variable Emp_Info Refcursor

Begin
   Open :Emp_Info For Select EName
                           , Sal
                        From Emp 
                       Where Job = 'SALESMAN' ;
End;
/

Print Emp_Info