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 -> Alternative to UNION

Alternative to UNION

From: Al <abenvin_at_gmail.com>
Date: 28 Jun 2006 06:42:16 -0700
Message-ID: <1151502136.416935.73670@j72g2000cwa.googlegroups.com>


 I'm trying to create a view in Oracle that will be accessed by a vendor application. Apparently the vendor app does something weird when it access a view that uses a UNION or UNION ALL statement. Is there an alternate method to UNION that can give the same result? The query below is a simplified version. Any help would be appreciated.   -Thanks, Al Benvin

CREATE OR REPLACE VIEW COMBO_V AS
SELECT *
  FROM (SELECT ID
               FROM TABLE1)
  UNION ALL

            (SELECT ID
              FROM TABLE2)  ;
Received on Wed Jun 28 2006 - 08:42:16 CDT

Original text of this message

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