Oracle Database 11g Advanced PLSQL

Oracle11g: Advanced PL/SQL

• Introduction to PL/SQL

PL/SQL Programming Concepts: Review

• List restrictions on calling functions from SQL expressions
• Hand exceptions
• Manage dependencies
• Use Oracle-supplied packages

Designing PL/SQL Code

• Identify guidelines for cursor design
• Use cursor variables
• Create subtypes based on existing types

Working with Collections

• Create collections (nested table, array and associative arrays, PL SQL tables)
• Use collections methods
• Manipulate collections
• Distinguish between the different types of collections and their uses

Using Advanced Interface Methods

• Execute external C programs from PL/SQL
• Execute Java programs from PL/SQL

Implementing Fine-Grained Access Control for VPD

• Explain the process of fine-grained access control
• Implement and test fine-grained access control

Manipulating Large Objects

• Create and manage LOB data types
• Use the DBMS_LOB PL/SQL package
• Use of temporary LOBs

Administering SecureFile LOBs

• Describe SecureFile LOB features
• Enable SecureFile LOB deduplication, compression, and encryption
• Migrate BasicFile LOBs to the SecureFile LOB format

Performance and Tuning

• Use native and interpreted compilation methods
• Tune PL/SQL code
• Enable intraunit inlining

Improving Performance with Caching

• Improve memory usage by caching SQL result sets and using the DBMS_RESULT_CACHE package
• Write queries that use the result cache hint
• Set up PL/SQL functions to use PL/SQL result caching

Analyzing PL/SQL Code

• Run reports on source code
• Determine identifier types and usages
• Use DBMS_METADATA to retrieve object definitions

Profiling and Tracing PL/SQL Code

• Trace PL/SQL program execution
• Profile PL/SQL applications

Safeguarding Your Code Against SQL Injection Attacks

• Describe SQL injections
• Reduce attack surfaces
• Use DBMS_ASSERT
• Design immune code
• Test code for SQL injection flaws

International Student Fee : 250 USD | 900 AED | 900 SAR

Related Courses

Oracle Techno Functional Consultant – Oracle Apps R12

Diploma SAP ERP Complete All-in-One Course
Oracle ERP R12 Supplychain Management
R12i Oracle E Business Suite Fundamentals
Oracle E-Business Suite R12 Applications DBA
Oracle Fusion Financials Cloud – 1Z0-408