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:41:31 -0800
Message-ID: <0552cf9c.62c274b7@usw-ex0109-066.remarq.com>


Last time I wrote it correctly, but alta vista has deleted again part of my script.

Trying this:

select col1,col2,col3,1 from tab1 where your-condition union all
select col1,col2,col3,0 from tab1 where your-reverse-condition;

Received on Fri Dec 31 1999 - 05:41:31 CST

Original text of this message

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