Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> I am looking for substitution of CASE or IF in SELECT
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