Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using bulk collect with union-statement

Re: Using bulk collect with union-statement

From: Anurag Varma <avoracle_at_gmail.com>
Date: 25 Jul 2005 08:09:50 -0700
Message-ID: <1122304190.416263.63170@g49g2000cwa.googlegroups.com>

select name
bulk collect into enums
from (select name from table where ....

          union
          select name from table where ...)
;

Anurag Received on Mon Jul 25 2005 - 10:09:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US