RE: Arrays in pl/sql using %rowtype

Rajiv,

Here is an example of how to use array in PL/SQL

-- introduce a new datatype
SQL> create or replace type arrays as table of varchar2(256);

-- using the PL/SQL

declare
        aData    arrays := arrays();
begin
        aData.extend(100);
        for i in 1..100 loop
                aData(i) := to_char( i );
                dbms_output.put_line( 'Value : '||aData(i) );
        end loop;
end;

-- not it is up to you on how your creative imagination will react on the said 
example.

Regards,
Lito

-----Original Message-----
From:   Rajiv Khatri [SMTP:rajiv.khatri@xxxxxxxxx]
Sent:   Tuesday, March 11, 2003 11:58 AM
To:     Oracle
Subject:        [oracle] Arrays in pl/sql using %rowtype

Can anyone send me an example of how to use and array of %Rowtype in
pl/sql.?
Rajiv



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx