This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:oracle-advanced-sql [2022/03/07 09:20] admin |
kurs:oracle-advanced-sql [2022/03/14 14:23] (current) admin |
||
---|---|---|---|
Line 1: | Line 1: | ||
[[RDBMS]] | [[RDBMS]] | ||
+ | [[DB Sprachen]] | ||
[[Fragen Dezember 2018]] | [[Fragen Dezember 2018]] | ||
Line 9: | Line 10: | ||
[[einfache selects]] | [[einfache selects]] | ||
+ | |||
+ | [[CTE Common Table Expression - With Clause]] | ||
+ | |||
+ | [[Relationen]] | ||
+ | |||
+ | [[Data Dictionary Views]] | ||
[[bind und substitution variablen]] | [[bind und substitution variablen]] | ||
Line 39: | Line 46: | ||
[[aggregat/summenfunktionen]] | [[aggregat/summenfunktionen]] | ||
+ | |||
+ | [[listagg]] | ||
[[rank]] | [[rank]] | ||
+ | |||
+ | [[pivot]] | ||
[[group by Beispiele]] | [[group by Beispiele]] |