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-pl-sql [2014/11/03 15:34] mh |
kurs:oracle-pl-sql [2015/04/16 09:32] mh |
||
---|---|---|---|
Line 49: | Line 49: | ||
[[cursor employees per department]] | [[cursor employees per department]] | ||
+ | |||
+ | === Beispielgruppe Teilnehmer === | ||
+ | |||
+ | [[Migration von Nested Table zu m:n]] | ||
[[emp per department function]] | [[emp per department function]] | ||
Line 83: | Line 87: | ||
[[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] | [[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] | ||
+ | |||
+ | === Dynamisches SQL === | ||
[[execute immediate]] | [[execute immediate]] | ||
Line 95: | Line 101: | ||
[[sqlldr sql loader]] | [[sqlldr sql loader]] | ||
+ | |||
+ | |||
+ | ==== Trigger ==== | ||
+ | |||
+ | [[teilnehmer journal trigger]] | ||
[[row trigger]] | [[row trigger]] |