SELECT manager_id, job_id, SUM(salary) from hr.employees WHERE manager_id < 120 GROUP
BY CUBE (job_id, manager_id);
2. // все NULL значения получились из-за группировки
SELECT manager_id, job_id, SUM(salary), GROUPING (manager_id) GRP_MNGR, GROUPING
(job_id) GRP_JOB from hr.employees WHERE manager_id < 120 GROUP BY CUBE (manager_id,
job_id);
3. SELECT department_id, job_id, manager_id, AVG(salary) FROM hr.employees GROUP BY
GROUPING SETS ((department_id, job_id, manager_id), (department_id, manager_id),(job_id,
manager_id));
4. SELECT * FROM dual MODEL DIMENSION BY (0 seq) MEASURES (0 val) RULES ITERATE (20)
(val[iteration_number] = val[iteration_number - 1] + val[iteration_number - 2], val[1] = 1, val[0]
= 0)
5. SELECT * FROM sales_view WHERE country IN ('Japan', 'Singapore') MODEL RETURN UPDATED
ROWS PARTITION BY (country) DIMENSION BY (prod, year) MEASURES(sale sales) RULES
(sales['Bounce', 2007] = sales['Bounce', 2005] + sales['Bounce', 2006], sales['Y Box', 2007] =
sales['Y Box', 2006], sales['2_Products', 2007] = sales['Bounce', 2007] + sales['Y Box', 2007])
6. SELECT * FROM sales_view WHERE country = 'France' MODEL RETURN UPDATED ROWS
PARTITION BY (country) DIMENSION BY (prod, year) MEASURES(sale sales) RULES
(sales['Bounce', 2008] = MAX(sales) [CV (prod), 2002 <= year AND year <= 2005] + 100);
7. SELECT * FROM sales_view WHERE country = 'Germany' MODEL RETURN UPDATED ROWS
PARTITION BY (country) DIMENSION BY (prod, year) MEASURES(sale sales) RULES UPSERT
(sales['Bounce', FOR year FROM 2005 TO 2007 INCREMENT 1] = sales['Mouse Pad', CV (year)] +
0.2 * sales['Y Box', CV (year)]);