Conditional Select 1

[Guest_imported]

I found this SQL for SQL 7 and was looking for something similar in Oracle. I looked in the reference manuals and didn't come up with anything. I wanted to know if you knew of anything similar to it in Oracle. It basically conditionally sets a value based upon the value of another.


SELECT Flag = CASE WHEN ID =0 THEN 1 ELSE 0 END, id
FROM TableX
WHERE 0=0

 

[karluk]

No doubt this could be done using the decode function. However a direct calculation is possible:

select sign(-abs(id))+1 as flag, id
FROM TableX;

 

[Guest_imported]

So is this how I do it?


SELECT DECODE (flag,0, '1','0') ,ID
FROM TableX
WHERE 0=0

 

[carp]

More like
SELECT DECODE(id,0,'0',1,'1','NONE') FLAG, id FROM my_table;

 

[karluk]

I think the following would work

select decode(id,0,'1','0') as flag, id
FROM TableX;