Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> newbie: conditions in expressions
i seem to miss some very basic concept in oracle, but how can i use conditions in select-expressions?
neither
select (1=1) as mytrue from dual;
nor
select ord(0 is not null) as mytrueint from dual;
nor
select if 1=1 then 42 else 0 endif as myweiredcalculation from dual
work?!
do i really have to code functions for stuff like "col is null" or use unions (select 1 from a where col is null union select 0 from a where col is not null)?!
ciao, jan Received on Fri Jan 29 1999 - 08:51:23 CST