Advanced and Useful PL/SQL Tools and Techniques
Write PL/SQL the way the designer intended
Description:In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You’ll learn how it interfaces with the database and other applications in the most efficient manner.
- PL/SQL designing best practices
- Create PL/SQL applications that use collections
- Implement a virtual private database with fine-grained access control
- Write code to interface with external C and Java applications
- Write code to interface with large objects and use SecureFile LOBs
- Write and tune PL/SQL code effectively to maximize performance
- Application Developers
- Database Administrators
- PL/SQL Developer
- Knowledge of SQL
- PL/SQL Programming experience
- Bulk Binding
- Using Autonomous Transactions
- The RETURNING clause
- Using Dynamic SQL
- Advanced Cursor usage
- Advanced Collections
- Invoker’s Rights vs. Definer’s Rights
- Selected Oracle 11g new features, including
- Advanced Packages issues
- Advanced memory and design issues
- Using PL/SQL compiler warnings to detect problematic code
- Oracle Supplied Packages: Overview
- Useful PL/SQL code, tips and tricks from the real world.

- על פי דרישה מועד פתיחה
- 9:00-16:30
ימים ושעות
- 24
שעות אקדמיות
- מתקדם
רמת הקורס
- עברית/English
שפת הדרכה
לבדיקת התאמה לקורס
ממליצים
לפתיחה והורדת סילבוס