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
sql scripts automatisch ausführen
zeitliche Nachverfolgung von Änderungen
zustand der session