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 | ||
|
kurs:oracle-pl-sql [2015/04/16 09:33] mh |
kurs:oracle-pl-sql [2016/05/04 15:18] (current) 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. Das Gehalt wird um 10% erhöht, wenn der Angestellte länger als 10 Jahre angestellt ist | ||
| + | |||
| [[typkonvertierung - casten]] | [[typkonvertierung - casten]] | ||
| Line 53: | Line 58: | ||
| [[Migration von Nested Table zu m-n]] | [[Migration von Nested Table zu m-n]] | ||
| + | |||
| + | [[Denormalisieren im Trigger fuer Person Journal]] | ||
| + | |||
| [[emp per department function]] | [[emp per department function]] | ||
| Line 136: | Line 144: | ||
| [[dbms_pipe]] | [[dbms_pipe]] | ||
| + | |||
| + | [[dbms_lock]] | ||
kurs/oracle-pl-sql.1429169593.txt.gz · Last modified: 2015/04/16 09:33 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
