Re: FORALL Statement

From: Norris <johnnie_at_cooper.com.hk>
Date: 15 Sep 1999 09:15:55 GMT
Message-ID: <7rno4c$172j$1@adenine.netfront.net>

Can you give me the exact URL? My program is something like this:

DECLARE
TYPE NumList IS VARRAY(20) OF NUMBER;
depts NumList := NumList(10, 30, 70, ...); -- department numbers BEGIN
...
FOR i IN depts.FIRST..depts.LAST LOOP
...
DELETE FROM emp WHERE deptno = depts(i); END LOOP;
END; Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:

> There is no matching construct,
> but if you use dbms_sql, there is
> an array processing option in 8.0.5,

> My web site carries an example.

> --

> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

> Norris wrote in message <7rnlmf$15od$1_at_adenine.netfront.net>...

>>In O8i PL/SQL, I can see the FORALL statement to improve the performance

> when doing bulk binding in parameter. What can I do if I am using 8.0.5?

>>
>>--
>>- Have several nice days...
>>- Opinions are mine and do not necessarily reflect those of the Corp.
>>http://www.ntfaq.com

>>http://www.cyberport.com/~tangent/programming/winsock/




--

- Have several nice days...
- Opinions are mine and do not necessarily reflect those of the Corp. http://www.ntfaq.com
http://www.cyberport.com/~tangent/programming/winsock/ Received on Wed Sep 15 1999 - 04:15:55 CDT