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 [2015/10/27 09:41] mh |
kurs:oracle-advanced-sql [2022/03/07 12:43] admin |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | [[RDBMS]] | ||
+ | |||
+ | |||
+ | [[Fragen Dezember 2018]] | ||
+ | |||
[[3rd party software]] | [[3rd party software]] | ||
Line 4: | Line 9: | ||
[[einfache selects]] | [[einfache selects]] | ||
+ | |||
+ | [[CTE Common Table Expression - With Clause]] | ||
+ | |||
+ | [[Relationen]] | ||
+ | |||
+ | [[bind und substitution variablen]] | ||
[[sessions + transactionen]] | [[sessions + transactionen]] | ||
Line 12: | Line 23: | ||
[[datum]] | [[datum]] | ||
+ | |||
+ | [[oracle outer joins]] | ||
[[joins]] | [[joins]] | ||
+ | |||
+ | [[joins - subsetvergleich]] | ||
+ | |||
+ | [[beispiele]] | ||
[[any all]] | [[any all]] | ||
Line 104: | Line 121: | ||
[[foreign keys finden]] | [[foreign keys finden]] | ||
+ | |||
+ | === DML === | ||
+ | |||
+ | [[create participant table]] |