declare
type numlist is table of number;
n numlist := numlist(10,23,31,12,45,12,34,45,56,12);
procedure print_numlist (the_list NumList) is output varchar2(128);
begin
if n.count = 0 then
dbms_output.put_line ('no elements in collection..');
else
for i in the_list.first .. the_list.last loop
output := output || nvl (to_char(the_list(i)) , 'NULL' ) || ' ';
dbms_output.put_line ('data ke ' || i || ' => '|| to_char(the_list(i)));
end loop;
dbms_output.put_line (' Output => ' || output );
end if;
end;
begin
dbms_output.put_line ('tees type ');
print_numlist (n);
end;
/
sdfgsfdg
-- source : https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/collections.htm#BABEDEGG
No comments:
Post a Comment