below is the PL/SQL code in which i m passing the parameters to the cursor.What i want is how to put the logic inside the PL/SQL to view the result
Code:
Declare
Cursor emp_cur ( p_id number,p_name varchar2 ) is
SELECT empno,ename FROM EMP WHERE EMPNO= p_id and ENAME=p_name;
BEGIN
OPEN emp_cur ( 7521,'WARD');
CLOSE emp_cur;
END;
/
