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 [2010/10/29 15:28] mh |
kurs:oracle-advanced-sql [2022/03/14 14:23] (current) admin |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | [[RDBMS]] | ||
+ | |||
+ | [[DB Sprachen]] | ||
+ | |||
+ | [[Fragen Dezember 2018]] | ||
+ | |||
[[3rd party software]] | [[3rd party software]] | ||
Line 4: | Line 10: | ||
[[einfache selects]] | [[einfache selects]] | ||
+ | |||
+ | [[CTE Common Table Expression - With Clause]] | ||
+ | |||
+ | [[Relationen]] | ||
+ | |||
+ | [[Data Dictionary Views]] | ||
+ | |||
+ | [[bind und substitution variablen]] | ||
+ | |||
+ | [[sessions + transactionen]] | ||
+ | |||
+ | [[indices]] | ||
[[case]] | [[case]] | ||
[[datum]] | [[datum]] | ||
+ | |||
+ | [[oracle outer joins]] | ||
[[joins]] | [[joins]] | ||
+ | |||
+ | [[joins - subsetvergleich]] | ||
+ | |||
+ | [[beispiele]] | ||
+ | |||
+ | [[any all]] | ||
+ | |||
+ | [[rownum|rownum limit]] | ||
+ | |||
+ | [[overlaps]] | ||
[[sets Gruppenoperatoren]] | [[sets Gruppenoperatoren]] | ||
[[metadata]] | [[metadata]] | ||
+ | |||
+ | [[aggregat/summenfunktionen]] | ||
+ | |||
+ | [[listagg]] | ||
+ | |||
+ | [[rank]] | ||
+ | |||
+ | [[pivot]] | ||
[[group by Beispiele]] | [[group by Beispiele]] | ||
Line 31: | Line 69: | ||
[[external tables]] | [[external tables]] | ||
+ | [[histogramm gehaltsverteilung]] | ||
+ | |||
+ | [[partition rank]] | ||
DML | DML | ||
Line 37: | Line 78: | ||
[[insert]] | [[insert]] | ||
+ | |||
+ | [[update]] | ||
[[doppelte zeilen l�schen]] | [[doppelte zeilen l�schen]] | ||
[[analyze indices/index]] | [[analyze indices/index]] | ||
+ | |||
+ | [[table for merge]] | ||
[[merge with table]] | [[merge with table]] | ||
Line 55: | Line 100: | ||
[[Version Table]] | [[Version Table]] | ||
+ | |||
+ | [[flashback data archive]] | ||
[[Datum_1]] | [[Datum_1]] | ||
Line 75: | Line 122: | ||
[[connect by prior]] | [[connect by prior]] | ||
+ | |||
+ | [[zeit zwischen jobs]] | ||
[[Regular Expression]] | [[Regular Expression]] | ||
+ | [[foreign keys finden]] | ||
+ | |||
+ | === DML === | ||
+ | [[create participant table]] |