declare
cursor s is select employee_id,first_name,salary
from emp ;
v_id emp.employee_id%type;
v_name emp.first_name%type;
v_sal emp.salary%type;
begin
open s;
fetch s into v_id,v_name,v_sal;
dbms_output.put_line(v_id||' '||v_name||' '||v_sal);
end;
OUTPUT:
100 Steven 24000
cursor s is select employee_id,first_name,salary
from emp ;
v_id emp.employee_id%type;
v_name emp.first_name%type;
v_sal emp.salary%type;
begin
open s;
fetch s into v_id,v_name,v_sal;
dbms_output.put_line(v_id||' '||v_name||' '||v_sal);
end;
OUTPUT:
100 Steven 24000
No comments:
Post a Comment