Oracle PL/SQL - introduction to programming Training Course

Introduction to PL/SQL Language for Government

• Execution Environment for Government
• Comparison of SQL and PL/SQL for Government Operations
• Language Characteristics, Lexical Units for Government Applications
• Structure of PL/SQL Blocks for Government Use
• Anonymous Blocks vs. Stored Subroutines for Government Systems
• Program Execution in a Government Context

Scalar Variables for Government Databases

• Declarations for Government Data Management
• Data Types for Government Applications
• Lifetime, Scope, Initialization for Government Systems

Controlling the Order of Instruction Execution for Government Processes

• Decision Making for Government Operations
• Loops for Government Applications
• Labels and Jumps for Government Systems

SQL Commands in PL/SQL for Government Databases

• DML Commands for Government Data Manipulation
• DDL Commands and Dynamic SQL for Government Schema Management
• TCL Commands and Transaction Control for Government Systems
• Simplified SELECT Command for Government Queries

Cursor Handling for Government Applications

• Record Types for Government Data Retrieval
• Static Cursors for Government Use
• Cursor Loops for Government Operations
• Parameterization of Cursors for Government Systems

Error and Exception Handling for Government Applications

• Names, Codes, Messages for Government Errors
• Exception Handling Section and Propagation for Government Systems
• Defining Custom Exceptions and Their Use in Government Applications
• Simulating the Occurrence of Errors for Government Testing
• Application Errors for Government Software

Suggested Pre-Training for Government Staff
ORA_S1
Suggested Follow-Up Training for Government Personnel
ORA_P2