kurs:oracle-pl-sql
Differences
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/09/10 21:22] 127.0.0.1 external edit |
kurs:oracle-pl-sql [2015/04/16 09:32] mh |
||
|---|---|---|---|
| Line 18: | Line 18: | ||
| [[labels]] | [[labels]] | ||
| - | |||
| - | [[employees_per_year]] | ||
| [[funktion]] | [[funktion]] | ||
| Line 26: | Line 24: | ||
| [[procedure upsert employee]] | [[procedure upsert employee]] | ||
| + | |||
| + | [[employees_per_year]] | ||
| [[procedure salary diff]] | [[procedure salary diff]] | ||
| Line 34: | Line 34: | ||
| [[table index by varchar2]] | [[table index by varchar2]] | ||
| + | |||
| + | ==== Cursor ==== | ||
| [[cursor übersicht]] | [[cursor übersicht]] | ||
| Line 40: | Line 42: | ||
| [[cursor mit parameter]] | [[cursor mit parameter]] | ||
| - | |||
| [[cursor + temporaere Tabllen]] | [[cursor + temporaere Tabllen]] | ||
| [[beispiele f. cursor]] | [[beispiele f. cursor]] | ||
| + | |||
| + | [[cursor employees per department]] | ||
| + | |||
| + | |||
| + | === Beispielgruppe Teilnehmer === | ||
| + | |||
| + | [[Migration von Nested Table zu m:n]] | ||
| [[emp per department function]] | [[emp per department function]] | ||
| Line 79: | Line 87: | ||
| [[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] | [[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] | ||
| + | |||
| + | === Dynamisches SQL === | ||
| [[execute immediate]] | [[execute immediate]] | ||
| Line 91: | Line 101: | ||
| [[sqlldr sql loader]] | [[sqlldr sql loader]] | ||
| + | |||
| + | |||
| + | ==== Trigger ==== | ||
| + | |||
| + | [[teilnehmer journal trigger]] | ||
| [[row trigger]] | [[row trigger]] | ||
kurs/oracle-pl-sql.txt · Last modified: 2016/05/04 15:18 by mh
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
