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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle gurus..please help with UNION query

Re: Oracle gurus..please help with UNION query

From: Alex Shnir <shnira_at_staff.juno.com>
Date: Fri, 16 Jul 1999 11:53:28 -0400
Message-ID: <378F5578.980BEF79@staff.juno.com> 





Just like this:




select int1, int2, char3, char4, int5, char6 from aaa
UNION



select int_01, 0, '', char_01, 0, 'aaaaaaaaaaaa' from bbb



> Only make sure that your dummy is matching the datatype



Received on Fri Jul 16 1999 - 10:53:28 CDT












Original text of this message













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