Oracle PL/SQL - introduction to programming

Knowledge of basic database concepts and SQL language basics in terms of queries, and DML, DDL and TCL commands. Basic programming skills in any structured language desirable.

Level
Basic
Form
Lecture, Presentation, Workshop
Purpose of the training
The training is intended for people who work with databases as programmers using the SQL language and need to extend the possibilities of work with the mechanisms of the procedural language.
Benefits of completing the training
Become familiar with the capabilities of the PL/SQL language in extending the capabilities of the SQL language. To acquire the ability to efficiently write scripts in PL/SQL. Enabling you to develop your knowledge of PL/SQL at further stages of advancement.

Introduction to PL/SQL language

• Execution environment
• Comparison of SQL and PL/SQL
• Language characteristics, lexical units
• Structure of PL/SQL blocks
• Anonymous blocks vs. stored subroutines
• Program execution

Scalar variables

• Declarations
• Data types
• Lifetime, scope, initialization

Controlling the order of instruction execution

• Decision making
• Loops
• Labels and jumps

SQL commands in PL/SQL

• DML commands
• DDL commands and dynamic SQL
• TCL commands and Transactivity
• Simplified SELECT command

Cursor handling

• Record types
• Static cursors
• Cursor loops
• Parameterization of cursors

Error and exception handling

• Names, codes, messages
• Exception handling section and propagation
• Defining custom exceptions and their use
• Simulating the occurrence of errors
• Application errors

Suggested pre-training
ORA_S1
Suggested follow-up training
ORA_P2