Request availability or book by selecting a date: Scotland
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language. Skills Gained By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs. Together with the Oracle PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle PL/SQL Developer Certified Associate Examination #1Z0-147. Together with the Oracle SQL*Plus course, this course is suitable for delegates intending to sit the Introduction to Oracle SQL and PL/SQL Examination #1Z0-001. Prerequisites A working knowledge of Oracle's SQL*Plus or iSQLPlus products and practical experience in writing SQL statements. Course Outline - Program Blocks
- Variables and Constants
- Using SQL Statements within PL/SQL Programs
- Generating SQL*Plus and iSQLPlus Output
- IF Statements
- Basic Loops
- The WHILE and FOR Loops
- Nested and Labelled Loops
- Using Cursors
- Parameterised Cursors
- Handling Named and UnNamed Exceptions
- Generating User Defined Exceptions
- Nested and Labelled Block Structures
- PL/SQL Records
- PL/SQL Tables of Records
- Handling PL/SQL Tables
How to make a booking for the OPL-SQL-12 course
|
