 select empno
       , ename
       , sal
    from emp
   where deptno = 10
  /


 CLARK            2450
 KING             5000
 MILLER           1300
 select empno
       , ename
       , sal
    from emp
   where deptno = 10
   model
         dimension by (empno)
         measures (ename, sal)
         rules
         ()
  /


 CLARK            2450
 KING             5000
 MILLER           1300
 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'
         )
  /


 CLARK            2450
 KING             5000
 MILLER           1300
 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
         )
  /


 CLARK            2450
 KING             5000
 MILLER           1300
 VAN WIJK         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
         )
  /


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


 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'
         )
  /


 VAN WIJK                      30
 VAN WIJK                      20
 VAN WIJK                      10
