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: lemmchen <lemmi.lemmchen_at_gmx.net>
Date: 26 Jul 2005 02:28:08 -0700
Message-ID: <1122370088.832013.37760@g47g2000cwa.googlegroups.com>


Anurag Varma schrieb:
> select name
> bulk collect into enums
> from (select name from table where ....
> union
> select name from table where ...)
> ;
>
> Anurag

That's it, thank you ! Received on Tue Jul 26 2005 - 04:28:08 CDT

Original text of this message

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