This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
kurs:oracle-pl-sql [2010/12/22 14:50] mh |
kurs:oracle-pl-sql [2016/05/04 15:16] mh |
||
---|---|---|---|
Line 4: | Line 4: | ||
[[bind variablen im SQL]] | [[bind variablen im SQL]] | ||
+ | |||
+ | einfache add function, nimmt 2 Parameter und returniert die Summe [[funktion add]] | ||
+ | |||
+ | [[function F_GET_EMPLOYEE_SALARY]] retourniert das salary Aufruf mit first_name, last_name | ||
[[typkonvertierung - casten]] | [[typkonvertierung - casten]] | ||
Line 18: | Line 22: | ||
[[labels]] | [[labels]] | ||
- | |||
- | [[employees_per_year]] | ||
[[funktion]] | [[funktion]] | ||
[[funktion + datum]] | [[funktion + datum]] | ||
+ | |||
+ | [[procedure upsert employee]] | ||
+ | |||
+ | [[employees_per_year]] | ||
[[procedure salary diff]] | [[procedure salary diff]] | ||
Line 32: | Line 38: | ||
[[table index by varchar2]] | [[table index by varchar2]] | ||
+ | |||
+ | ==== Cursor ==== | ||
[[cursor übersicht]] | [[cursor übersicht]] | ||
Line 42: | Line 50: | ||
[[beispiele f. cursor]] | [[beispiele f. cursor]] | ||
+ | |||
+ | [[cursor employees per department]] | ||
+ | |||
+ | |||
+ | === Beispielgruppe Teilnehmer === | ||
+ | |||
+ | [[Migration von Nested Table zu m-n]] | ||
+ | |||
+ | [[Denormalisieren im Trigger fuer Person Journal]] | ||
+ | |||
[[emp per department function]] | [[emp per department function]] | ||
+ | |||
+ | [[nested table als column type]] | ||
[[table als tabellendatentyp]] | [[table als tabellendatentyp]] | ||
+ | |||
+ | [[plsql Tables]] | ||
[[nested tables und collection operator]] | [[nested tables und collection operator]] | ||
Line 54: | Line 76: | ||
[[http://www.techonthenet.com/oracle/exceptions/named_system.php|Vordefinierte Fehler]] | [[http://www.techonthenet.com/oracle/exceptions/named_system.php|Vordefinierte Fehler]] | ||
+ | |||
+ | [[upsert emp]] | ||
[[exception raise und raise_application_error]] | [[exception raise und raise_application_error]] | ||
Line 70: | Line 94: | ||
[[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] | [[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] | ||
+ | |||
+ | === Dynamisches SQL === | ||
[[execute immediate]] | [[execute immediate]] | ||
Line 76: | Line 102: | ||
[[dbms_sql]] | [[dbms_sql]] | ||
+ | |||
+ | [[dbms_sql mit fetch und cursor]] | ||
[[write to file utl_file]] | [[write to file utl_file]] | ||
[[sqlldr sql loader]] | [[sqlldr sql loader]] | ||
+ | |||
+ | |||
+ | ==== Trigger ==== | ||
+ | |||
+ | [[teilnehmer journal trigger]] | ||
[[row trigger]] | [[row trigger]] | ||
Line 86: | Line 119: | ||
[[bonus journal trigger]] | [[bonus journal trigger]] | ||
+ | |||
+ | [[journal trigger mit denormalisieren]] | ||
[[kreis tabelle + trigger]] | [[kreis tabelle + trigger]] | ||
Line 94: | Line 129: | ||
[[instead of trigger]] | [[instead of trigger]] | ||
+ | |||
+ | [[schema trigger]] | ||
[[BFILE und LOB]] | [[BFILE und LOB]] | ||
[[v_dep_emp]] | [[v_dep_emp]] | ||
+ | |||
+ | [[Oracle Text]] | ||
[[zeilen vergleichen]] | [[zeilen vergleichen]] | ||
+ | |||
+ | [[ultimo_vormonat]] | ||
+ | |||
+ | [[dbms_pipe]] | ||
+ | |||
+ | [[dbms_lock]] |