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 -> I am looking for substitution of CASE or IF in SELECT

I am looking for substitution of CASE or IF in SELECT

From: Michal Kulakovsky <michal.kulakovsky_at_definity.cz>
Date: 14 Aug 2000 13:31:01 +0100
Message-ID: <3997d875.0@news.cvut.cz>

I am migrating from MS SQL and there I used CASE in SELECT

like this

SELECT CASE	WHEN 
    	datepart(wk,getdate()) >= $S1 THEN '1'
	ELSE '0'
	END "ok" from table1;

Does Oracle support something like MS-SQL CASE in SELECT ?

Can anyone help me ?

Thank you. Received on Mon Aug 14 2000 - 07:31:01 CDT

Original text of this message

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