Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> FW: pl/sql array processing?
My following message did not seem to make it to oracle-l.freelists. Let me
try it again.
Guang
I have the folliwng pl/sql code for oracle 8173. I am wondering if there is a way to make it faster by not looping each array elements, but doing some kind of "forall" opration to my_package.function?
declare
type numTbl is table of number index by binary_integer;
refTbl numTbl; i number; str varchar2(30);
refTbl (1) := 1; refTbl (9) := 1; refTbl(15) := 1; refTbl(99) := 1;
i := refTbl.first;
while i is not null loop
dbms_output.put_line ('i=' || i);
str:= my_package.function(i);
i := refTbl.next(i);
end loop;
end;
/
TIA. Guang
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: gmei_at_incyte.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 27 2004 - 11:54:29 CST
![]() |
![]() |