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
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 [2014/11/18 12:47]
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]]
 +
  
 [[emp per department function]] [[emp per department function]]
Line 79: Line 83:
  
 [[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]] [[unterschiedliche objecte mit Abhaengigkeiten in datenbanken finden]]
 +
 +=== Dynamisches SQL ===
  
 [[execute immediate]] [[execute immediate]]
kurs/oracle-pl-sql.txt · Last modified: 2016/05/04 15:18 by mh