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:[email protected]]
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 [email protected].