Array in Oracle PL/SQL

declare
type tobj is RECORD (
ld_id number,
qty number);
type tstrarr is table of tobj index by binary_integer;
strarr tstrarr;
begin
strarr(1).ld_id:='1';
strarr(1).qty:='11';
strarr(2).ld_id:='2';
strarr(2).qty:='22';
for arr in 1..strarr.count loop
dbms_output.put_line(strarr(arr).ld_id);
dbms_output.put_line(strarr(arr).qty);
end loop;
end;

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS

0 Response to "Array in Oracle PL/SQL"

Post a Comment