Background
Knowledge of PostgreSQL relational database systems, SQL and the concepts behind procedural languages.
Main topics
- Introduction PL/SQL:
'Inline' versus 'Stored' procedures
- SQL support:
Writing SQL in a procedural environment
- Variables and constants - records, collections:
Explicit declaration • implicit declaration
- Logical comparisons:
If-then-else structure
- Conditional and iterative control:
For-loop • do-while loop • loop-endloop • goto
- Cursor management:
Implicit and explicit cursors • attributes • cursor-for loop
- Error treatment:
Pre-defined exceptions • application exceptions
- Procedural objects:
functions • stored procedures • triggers
| SESSION INFO AND ENROLMENT |