Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to PL / SQL
- Runtime Environment
- Construction and types of PL / SQL blocks
- Declaring and using variables
- Control statements, decisions, loops
SQL statements in PL / SQL
- DML commands
- DDL and dynamic SQL
- TCL commands and transactional
- SELECT
Procedures and Functions
- Create and delete
- Parameterization
- Passing parameters by value and reference, nocopy
Handling errors and exceptions
Create and use cursors
- Records
- static cursors
- Parameterizing cursors
- Cursor FOR UPDATE
Associative arrays
Packages
- The structure of the package: the specification and body
- Section Initialization and global variables, memory management, an instance of the package
- Encapsulation, overloading programs, pre-declaration procedures
Triggers
- DML triggers
- The triggers Drives (INSTEAD OF)
- The triggers system
- New features in Oracle 11g triggers
Examples of application packages built
- Writing to a file through UTL_FILE
- Sending e-mails
Management code and compiler
- Encryption code (dynamic obfuscation, wrap)
- conditional Compilation
- The relationships between objects
- Warnings
Requirements
- Basic skills in any programming language, object-oriented structural or
- The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
28 Hours
Testimonials (5)
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
During the training, all modules were discussed in great detail - for two days of training - and that was what I cared about the most.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I like fact, that after each section we had exercises. It helps to remember discussed topic.