cursor

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

[Quoted] 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;

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