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: views...

Re: views...

From: kai regi <kaiNOkaSPAM_at_rs.ee.invalid>
Date: Fri, 31 Dec 1999 03:26:43 -0800
Message-ID: <0dfee094.5ee5e5df@usw-ex0109-066.remarq.com> 





Oops,



the first query must be like this:



select col1,col2,col3,1 from tab1 where
<your_condition>


union all


select col1,col2,col3,0 from tab1 where <your reverse
condition>;



kai





Received on Fri Dec 31 1999 - 05:26:43 CST












Original text of this message













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