User Tools

Site Tools


kurs:oracle-pl-sql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
kurs:oracle-pl-sql [2015/04/16 09:33]
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 53: Line 57:
  
 [[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 143:
  
 [[dbms_pipe]] [[dbms_pipe]]
 +
 +[[dbms_lock]]
kurs/oracle-pl-sql.txt ยท Last modified: 2016/05/04 15:18 by mh