Opleiding: PL/SQL database programming (EN/NL/FR)
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 3 day ABIS course are (1) to describe and exercise the procedural characteristics that are added by PL/SQL to SQL, and (2) to know the advantages of using stored procedures, functions and triggers. This course is designed for application programmers, developers and DBAs. Knowledge of Oracle relational database systems, SQL and the concepts behind procedural languages is required.
Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.
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/Audience: This course is designed for application programmers, developers and DBAs.
Background/Prerequisites: Knowledge of Oracle relational database systems, SQL and the concepts behind procedural languages.
Training Method/Didactics: Classroom instruction with practical exercises.
Duration: 3 days.
