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 [2020/05/26 09:38] admin |
kurs:oracle-advanced-sql [2022/03/14 14:23] (current) admin |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | [[RDBMS]] | ||
| + | |||
| + | [[DB Sprachen]] | ||
| + | |||
| [[Fragen Dezember 2018]] | [[Fragen Dezember 2018]] | ||
| Line 6: | 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 16: | Line 26: | ||
| [[datum]] | [[datum]] | ||
| + | |||
| + | [[oracle outer joins]] | ||
| [[joins]] | [[joins]] | ||
| Line 34: | Line 46: | ||
| [[aggregat/summenfunktionen]] | [[aggregat/summenfunktionen]] | ||
| + | |||
| + | [[listagg]] | ||
| [[rank]] | [[rank]] | ||
| + | |||
| + | [[pivot]] | ||
| [[group by Beispiele]] | [[group by Beispiele]] | ||