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: Query Help

Re: Query Help

From: Bertrand Guillaumin <guillauminb_at_hotmail.com>
Date: 22 Mar 2006 04:43:24 -0800
Message-ID: <1143031404.368391.154800@e56g2000cwe.googlegroups.com> 





Try :



SELECT NAME1 as NAME3 FROM TABLE UNION ALL SELECT NAME2 as NAME3 FROM
TABLE etc...



Repeating union all as many times as you need.



Regards,
Received on Wed Mar 22 2006 - 06:43:24 CST












Original text of this message













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