I find that
"case when not m[1] is present then" outputs ORA-03113:
Why?
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
select * from dual model
dimension by(0 as d)
measures(1 as m)
rules(
m[any] = case when not m[1] is present then 1 end);
ORA-03113:
Below one is alterNative solution.
select * from dual model
dimension by(0 as d)
measures(1 as m)
rules(
m[any] = case when presentv(m[1],1,0) = 0 then 3 end);
D M
- -
0 3