Oracle SQL多维建模

Listing B

SELECT order_mode, order_year, tot
FROM order_data_view
MODEL
  RETURN UPDATED ROWS
  DIMENSION BY (order_mode, order_year)
  MEASURES (order_total tot)
  RULES UPDATE (
    tot[ANY, 1998] = 
       SUM(tot)[CV(order_mode),order_year <=  1998],
    tot[ANY, order_year >1998] = 
        tot[CV(order_mode),CV(order_year)]
  )
ORDER BY order_year, order_mode
/


SQL> @model_b

ORDER_MO ORDER_YEAR               TOTAL                                         
-------- --------------- --------------                                         
direct   1998                377,442.10                                         
online   1998                100,056.60                                         
direct   1999              1,274,078.80                                         
online   1999              1,271,019.50                                         
direct   2000                252,108.30                                         
online   2000                393,349.40                                         

6 rows selected.

SQL>