[9.2i] CASE WHEN ... THEN null ELSE null END gives 'Not enough arguments...
445476Nov 24 2009 — edited Nov 28 2009Gents, can someone explain:
CASE WHEN ... THEN null ELSE null END
gives "Not enough arguments for function"
These work:
CASE WHEN ... THEN '' ELSE '' END
CASE WHEN ... THEN null ELSE '' END
CASE WHEN ... THEN '' ELSE null END
So what's the deal with my first one?
But if I write:
create table a(a varchar2(100))
;
insert into a values(null)
;
select case when dummy='whatever' then null else a.a end from a cross join dual
a.a is null, so why doesnt it explode?