This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
kurs:oracle-advanced-sql [2010/10/30 15:02] mh |
kurs:oracle-advanced-sql [2018/08/22 16:14] admin |
||
---|---|---|---|
Line 4: | Line 4: | ||
[[einfache selects]] | [[einfache selects]] | ||
+ | |||
+ | [[sessions + transactionen]] | ||
[[indices]] | [[indices]] | ||
Line 13: | Line 15: | ||
[[joins]] | [[joins]] | ||
- | [[rownum]] | + | [[joins - subsetvergleich]] |
+ | |||
+ | [[beispiele]] | ||
+ | |||
+ | [[any all]] | ||
+ | |||
+ | [[rownum|rownum limit]] | ||
+ | |||
+ | [[overlaps]] | ||
[[sets Gruppenoperatoren]] | [[sets Gruppenoperatoren]] | ||
[[metadata]] | [[metadata]] | ||
+ | |||
+ | [[aggregat/summenfunktionen]] | ||
+ | |||
+ | [[rank]] | ||
[[group by Beispiele]] | [[group by Beispiele]] | ||
Line 35: | Line 49: | ||
[[external tables]] | [[external tables]] | ||
+ | [[histogramm gehaltsverteilung]] | ||
+ | |||
+ | [[partition rank]] | ||
DML | DML | ||
Line 47: | Line 64: | ||
[[analyze indices/index]] | [[analyze indices/index]] | ||
+ | |||
+ | [[table for merge]] | ||
[[merge with table]] | [[merge with table]] | ||
Line 84: | Line 103: | ||
[[connect by prior]] | [[connect by prior]] | ||
- | [[Regular Expression]] | + | [[zeit zwischen jobs]] |
+ | [[Regular Expression]] | ||
+ | [[foreign keys finden]] |