U can try this method.. Set serveroutput on
declare
cursor dept_cursor is
select department_id,department_name
from departments
where department_id < 100
order by department_id;
cursor...
Type: Posts; User: bhagwati; Keyword(s):
U can try this method.. Set serveroutput on
declare
cursor dept_cursor is
select department_id,department_name
from departments
where department_id < 100
order by department_id;
cursor...
we can also use parametrized cursor..........
try this-
set serveroutput on
declare
v_id employees.employee_id%type;
v_name employees.last_name%type;
cursor c(v_dept number) is
...
thanx 4 this ...