[[RDBMS]]

[[DB Sprachen]]

[[Fragen Dezember 2018]]

[[3rd party software]]

[[http://www.adp-gmbh.ch/ora/sqlplus/use_vars.html|bind variablen in sqlplus]]

[[einfache selects]]

[[CTE Common Table Expression - With Clause]]

[[Relationen]]

[[Data Dictionary Views]]

[[bind und substitution variablen]]

[[sessions + transactionen]]

[[indices]]

[[case]]

[[datum]]

[[oracle outer joins]]

[[joins]]

[[joins - subsetvergleich]]

[[beispiele]]

[[any all]]

[[rownum|rownum limit]]

[[overlaps]]

[[sets Gruppenoperatoren]]

[[metadata]]

[[aggregat/summenfunktionen]]

[[listagg]]

[[rank]]

[[pivot]]

[[group by Beispiele]]

[[eine Tabelle mehrfach verwenden]]

[[select mit group by subquery]]

[[einfache subquery]]

[[corellated subquery vs pseudotable]]

[[select mit where in subquery]]

[[correlated subquery mit having]]

[[external tables]]

[[histogramm gehaltsverteilung]]

[[partition rank]]

DML

[[delete truncate drop]]

[[insert]]

[[update]]

[[doppelte zeilen l�schen]]

[[analyze indices/index]]

[[table for merge]]

[[merge with table]]

[[merge]]

[[merge accountants]]

[[merge werte einfuegen]]

[[merge in procedure]]

[[Kopieren von einer anderen Tabelle]]

[[Version Table]]

[[flashback data archive]]

[[Datum_1]]

[[zeit und intervalle]]

[[grouping sets]]

[[case + group by]]

[[rollup und cube]]

[[group by year]]

[[correlated subquery]]

[[with clause]]

[[complex with clause]]

[[connect by prior]]

[[zeit zwischen jobs]]

[[Regular Expression]]

[[foreign keys finden]]

=== DML ===

[[create participant table]]