set echo on select empno , ename , sal from emp where deptno = 10 / select empno , ename , sal from emp where deptno = 10 model dimension by (empno) measures (ename, sal) rules () / select empno , ename , sal from emp where deptno = 10 model dimension by (empno) measures (sal) rules () / select empno , ename , sal from emp where deptno = 10 model dimension by (empno) measures (ename,sal) rules ( ename[7777] = 'VAN WIJK' ) / select empno , ename , sal from emp where deptno = 10 model dimension by (empno) measures (ename,sal) rules ( ename[7777] = 'VAN WIJK' , sal[7777] = 2500 ) / select empno , ename , sal from emp where deptno = 10 model return updated rows dimension by (empno) measures (ename,sal) rules ( ename[7777] = 'VAN WIJK' , sal[7777] = 2500 ) / select empno , ename , sal , deptno from emp model return updated rows dimension by (empno) measures (ename,sal,deptno) rules ( ename[7777] = 'VAN WIJK' ) / select empno , ename , sal , deptno from emp model return updated rows partition by (deptno) dimension by (empno) measures (ename,sal) rules ( ename[7777] = 'VAN WIJK' ) /