PL/SQL – programming language in Oracle databases

This course is designed to familiarize trainees with the programming language PL/SQL as a programming language in Oracle databases and programming language in an integrated development environment Oracle Developer. There are presented the principle of operation of this language on the database server, creating both basic and complex programming structures. The course covers the building code, automating the operation in the database, the construction of dynamic code as well as issues of protection of created programs.

After completing the course, participants will know how to:

create anonymous blocks
create and execute procedures and functions, pass and return values.
generate, capture and handle exceptions.
use cursors
create, share and use records
create and manage packages.
create DML triggers to automate operations manipulating data
create autonomous transactions

The course is intended for all who create applications based on Oracle relational databases using the PL/SQL programming language.

Trainees should be familiar with basic SQL functionality as well as bases of programming knowledge.

The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.

2 days, 16 training hours

se of PL / SQL language

• Anonymous blocks

• objects stored on the server side

• objects stored at format application and reports application level

PL / SQL in SQL * Plus and SQL Developer

• Running the code

• bind variables

• capturing the results

Data Types

• scalar

• complex

• Anchored

• LOB

Cooperation with the database

Blocks anonymous PL / SQL

• Running

• Parameters passing

Conditional instructions

Iteration instructions

Procedures

Functions

• different modes of passing parameters

• returning values

Handling Exceptions

• Built-in errors

• User errors

• Codes and names of errors

• Exceptions handle built-in functions

Cursors

• Implicit cursors

• Creating and using explicit cursors

• Cursor attributes

• Cursor parameterization

Dynamic SQL

• Execute immediate

Records

Packages

• specification

• body

• Overloading procedures and functions

• Code wrapping

Database Triggers

• Types of triggers

• DML triggers

• Row level and statement level triggers

• Use of pseudo-records

• Use of Conditional Predicates

• Triggers restrictions

• Triggers management

Autonomous transaction

For detailed information, please reach out to us at training@comarch.com.

PL/SQL – programming language in Oracle databases

PL/SQL – programming language in Oracle databases

Full program

Similar trainings

Consultant: