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

Home -> Community -> Usenet -> c.d.o.tools -> Generating Binary Column

Generating Binary Column

From: <nevergiveup_at_my-deja.com>
Date: Mon, 12 Feb 2001 00:34:27 GMT
Message-ID: <967b2j$ssd$1@nnrp1.deja.com> 






Hello,



I have Table T with Column X.


I want to generate Column Y in the same table, or in the new view V.



I want Y to have the value of 1 if X >= 5, and 0 if otherwise.



How would I do this?


I have been looking into Decode, and it doesn't seem to do it.
I think Decode only works for text matching.



Thank you,



Gingko




Sent via Deja.com


http://www.deja.com/
Received on Sun Feb 11 2001 - 18:34:27 CST












Original text of this message













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