This is an old revision of the document!
3rd party software
bind variablen in sqlplus
einfache selects
sessions + transactionen
indices
case
datum
joins
any all
rownum
overlaps
sets Gruppenoperatoren
metadata
aggregat/summenfunktionen
rank
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