Wednesday, August 28, 2019

PL/SQL Oracle - Collections in Records





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

Tutorial blog - Menambahkan Syntax Highlighter di Blogger

berikut adalah contoh bagaimana cara menambahkan syntax codingan kalian di dalam postingan let count = 0; const intervalId = setInterv...