cursor

From: <daud11_at_hotmail.com>
Date: Thu, 02 Nov 2000 10:34:27 GMT
Message-ID: <8trfvj$oor$1@nnrp1.deja.com>

Part of my PL/SQL program has the code below and this part is very slow.

Is there a better way of writing it? Is cursor really slow?

                open c1;
                loop
                        fetch c1 into rs1;
                        exit when c1%notfound;

                        insert into iq_smt_tmp_assy_partnum_rd
                        (col1, col2......)
                        select * from a_table where
                        condition = rs1.column_name and
                        condition2 = rs1.col_name2 etc
                end loop;

Daud11

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 02 2000 - 04:34:27 CST