retreving data using select statement
v_sal emp.sal%TYPE
select ename, sal infor v_name, v_sal from emp which only stores just 1 record; it also
has a implicit cursor created by oracle
<delete from emp> also will create cursors
way to use cursor
declare open fetch open
cursor cl is select empno,ename from emp;
open cl;
loop
fetch cl into v_eno, v_name;
exit when cl%NOTFOUND;
end loop;
close cl
//this is a simplifized version
for rec in cl loop
end loop;
cursor attribute
cl%isopen
cl%found
cl%notfound
cl%rowcount
Cursors With Parameters
cursor cl (v_deptno NUMBER) IS
Oracle PL/SQL Reference Cursor
the cursor content will be determined in the beging block during the runtime
type emp_refcursor is REF CURSOR
emp_cv emp_refcurosr
PL/SQL Bulk Collect and Bulk Bind //what is the benificiency? the anwser is the performance improvement
type empnotab IS TABLE OF emp.empno%TYPE
l_EMPNO empno empnotab
curesor cl is select empno from emp
FETCH cl BULK COLLECT INTO L_EMPNO
//for x in c loop; null;end loop;