This is an old revision of the document!
pivot dynamisch
WITH T AS ( SELECT department_id, JOB_id, salary FROM employees where job_id in ( 'ST_CLERK', 'SH_CLERK' ) ) SELECT * FROM T PIVOT ( MIN(SALary) AS MINSAL, MAX(SALary) AS MAXSAL FOR (JOB_ID) in ( 'ST_CLERK', 'SH_CLERK') ) ORDER BY department_id
select department_id, listagg(last_name, ', ') within group (order by job_id desc ) a from employees group by department_id;
sql scripts automatisch ausführen
zeitliche Nachverfolgung von Änderungen
zustand der session