Re: Slow Query in PL/SQL Block

From: Daniel <danielroy10junk_at_hotmail.com>
Date: 15 Aug 2005 06:57:17 -0700
Message-ID: <1124114237.821597.37150@g14g2000cwa.googlegroups.com>

Here is a code snippet I found in this group. Just adapt it to your tables/columns:

create or replace
procedure testproc is

        cursor c is select n from test ;
        type t is table of number index by binary_integer;
        r t;
begin
        r.delete;
        open c;
        fetch c bulk collect into r;
        close c; 

end testproc;
/

Daniel Received on Mon Aug 15 2005 - 08:57:17 CDT