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 -> Case Statement

Case Statement

From: Mason Liu <masonliu_at_msn.com>
Date: Fri, 3 Nov 2000 18:16:37 -0600
Message-ID: <OnFYrRfRAHA.369@cpmsnbbsa07> 






Does Oracle8 support the case statement in SELECT.



For example:



SELECT (CASE col_a WHEN 1 THEN 'ONE' WHEN 2 THEN 'TWO' ELSE 'UNKNOWN' END)
FROM table...



I know decode() can accomplish this, but I like to know this for migration
reasons.



Thanks,



Mason Liu
Received on Fri Nov 03 2000 - 18:16:37 CST












Original text of this message













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