Référence : © Oracle UniversityD80343GC20
Duration : 3 jours
In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.
Benefits To You
Students will benefit from using advanced features of program design, packages, cursors, extended interface methods, and collections and students learn how to write powerful PL/SQL programs.
Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered. Students learn how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.
Students are introduced to the Virtual Private Database (VPD) to implement security policies and they learn techniques and tools to strengthen their applications against SQL injection attacks.
|Languages||These scheduled public sessions are offered in English or in French (FR). The educational material is in English.|
Oracle Database Exadata Express Cloud Service
Overview of Collections
Using Collections in PL/SQL
Manipulating Large Objects
Working with JSON Data
Using Advanced Interface Methods
Performance and Tuning
Improving Performance with Caching
Analyzing PL/SQL Code
Profiling and Tracing PL/SQL Code
Securing application through PL/SQL
Managing Access to data using PL/SQL
Safeguarding Your Code Against SQL Injection Attacks
Security Features implemented through PL/SQL