PL/SQL Collections PL/SQL Table Select………….. Fetch stmt declare type vel is table of employees%rowtype i vel a n!mber b n!mber be"in a#$dbms!tility."ettime select & b!l' collect into i from employees employees for ( in )..i.co!nt loop dbmso!tp!t.p!tline*i*(+.,rstname----i*(+.salary+ end loop b#$dbms!tility."ettime dbmso!tp!t.p!tline*a+ dbmso!tp!t.p!tline*b+ dbmso!tp!t.p!tline*ab+ end / PL/SQL Table 0ith C!rsor…..Fetch stmt declare type vel is table of employees%rowtype emp vel c!rsor empc!r is select & from employees a n!mber b n!mber be"in a#$dbms!tility."ettime open empc!r fetch empc!r b!l' collect into emp for i in emp.,rst..emp.last emp.,rst..emp .last loop dbmso!tp!t.p!tline*emp*i+.,rstname----emp*i+.salary+ end loop b#$dbms!tility."ettime dbmso!tp!t.p!tline*a+ dbmso!tp!t.p!tline*b+ dbmso!tp!t.p!tline*ab+ end / 1llob2ects 1llob2ect s PL/SQl Table 0ith C!rsor declare type vel is table of allob2ects.ob2ectname%type inde( by binaryinte"er v) vel c!rsor empc!r is select ob2ectname from allob2ects a n!mber*)3+
b n!mber*)3+ be"in a#$dbms!tility."ettime open empc!r fetch empc!r b!l' collect into v) for ( in )..v).co!nt loop dbmso!tp!t.p!tline*v)*(++ end loop dbmso!tp!t.p!tline*v).co!nt*++ b#$dbms!tility."ettime dbmso!tp!t.p!tline*a+ dbmso!tp!t.p!tline*b+ dbmso!tp!t.p!tline*ab+ end / 45L6 4789 *5P91T: 07T; %T
array declare type vel is varray*))3+ of employees%rowtype v) vel#$vel*+ be"in select & b!l' collect into v) from employees for i in v).,rst..v).last loop dbmso!tp!t.p!tline*v)*i+.,rstname----v)*i+.lastname+ end loop v).trim*?+ dbmso!tp!t.p!tline*v).co!nt+ end / 8ested Table declare type vel is table of employees%rowtype v) vel#$vel*+ be"in select & b!l' collect into v) from employees for i in v).,rst..v).last loop dbmso!tp!t.p!tline*v)*i+.,rstname----v)*i+.lastname+ end loop
v).trim*?+ dbmso!tp!t.p!tline*v).co!nt+ end / @:CA@9 declare type rec is record*name employees.,rstname%typeBid employees.employeeid %type+ i rec be"in select ,rstnameBemployeeid into i from employees where employeeid$)33 dbmso!tp!t.p!tline*i.name----i.id+ end /