PL/SQL – programming language in Oracle databases
Oracle Database Server
Duration
Start hour
Level
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:
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
