About ABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
PL/SQL database programming


During the development and/or control of programs for database processing, application programmers, developers and DBAs need more than the basic relational possibilities of Oracle SQL.

Therefore the objectives of this course are:

  • to describe and exercise the procedural characteristics that are added by PL/SQL to SQL;
  • to know the advantages of using stored procedures, functions and triggers.

Main topics

  • Introduction PL/SQL:

'Stand Alone' 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:

packages • functions • procedures • triggers

  • Oracle Supplied Packages

Intended for

This course is designed for application programmers, developers and DBAs.


Knowledge of Oracle relational database systems, SQL and the concepts behind procedural languages (see Oracle fundamentals course).

Training method

Classroom instruction with practical exercises.

Course leader

Bart Lemarcq, Kris Van Thillo.


3 days.


You can enrol by clicking on a date
datedur.lang.  location  price
22 Nov3?Leuven  (BE)1350 EUR  (excl. VAT) 
18 Dec3NWoerden  (NL)1350 EUR  (exempt from VAT) 

Global score

4.2/5 (based on 111 evaluations)


Goed, maar oefeningen zijn soms te ingewikkeld, om vast te stellen wat de kern van de oefening is, kom hier niet voor ingewikkelde formules, maar om de basis van het maken van procedures te begrijpen (, )
Prima (, )
een betere kennis van SQL was nuttig geweest (, )
goede inleidende cursus over PLSQL, goede manier overgebracht (, )
zeer goed en compleet (, )
prima om eerste indruk PLSQL te krijgen. (, )
PL/SQL gaat m.i. behoorlijk terug in de tijd. (Back to basics) (, )
Prima cursus (, )
Uiteraard was de cursus iets te kort en ging het wat snel maar het leek me voldoende voor wat we nodig hebben. (, )
Goede cursus met enthiousiaste cursurleider. (, )

Refresh this page to see other comments.