Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print PageAdvanced PL/SQL Tips and Techniques
Description:
The focus of this course is to advance attendee knowledge of the PL/SQL programming language. This is an excellent course for those people that need a better knowledge of the PL/SQL language. This course covers all the latest features of PL/SQL using databases Oracle9i, Oracle10g, and Oracle11g.
View other Oracle Courses available
View other Oracle Courses available
- Cost: Price on application
- Duration: 3 days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
A working knowledge of SQL and PL/SQL is required.
Oracle Architecture:
Introduction to PL/SQL :
o Syntax and language structure review
PL/SQL Topics :
o Package Usage (both User Defined and Oracle Defined Packages)
o Profiling/Debugging/Compiling
o Cursor Sharing/Cursor Variables
o Collections
o Dynamic SQL
o Autonomous Transactions
o PL/SQL Coding Tips
o Debugging PL/SQL
o PL/SQL Profiling
o Tracing PL/SQL
o Profiling/Debugging/Compiling
o Cursor Sharing/Cursor Variables
o Collections
o Dynamic SQL
o Autonomous Transactions
o PL/SQL Coding Tips
o Debugging PL/SQL
o PL/SQL Profiling
o Tracing PL/SQL
Attendees Receive:
• Study guide and relevant white papers
• Diskette full of useful SQL and SQL*Plus scripts
• A hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer
• Diskette full of useful SQL and SQL*Plus scripts
• A hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer
Day 1: Advanced Oracle PL/SQL:
- PL/SQL Overview/Review
- PL/SQL Compiler
- Definer/Invoker Rights
- Executing and Exception handling
- Autonomous Transactions
- Package Options
- Overloading
- Database Triggers
DML, Instead of, ServerError, Startup, Shutdown, Logon
- PL/SQL Compiler
- Definer/Invoker Rights
- Executing and Exception handling
- Autonomous Transactions
- Package Options
- Overloading
- Database Triggers
DML, Instead of, ServerError, Startup, Shutdown, Logon
Day 2: Advanced Oracle PL/SQL:
- Working with Cursors
User Defined Datatypes
Cursor Sharing
Cursor Variables
Strong vs Weak Cursors
- Working with Collections
Associate Arrays
Nested Tables
Varrays
Bulk Collect/Forall Bulk Binding
Using Collections for Reference Table
- Oracle Provided Packages
DBMS_Alert
DBMS_Job
DBMS_Output
DBMS_Scheduler
UTL_File
UTL_Mail
Other Provided Packages
User Defined Datatypes
Cursor Sharing
Cursor Variables
Strong vs Weak Cursors
- Working with Collections
Associate Arrays
Nested Tables
Varrays
Bulk Collect/Forall Bulk Binding
Using Collections for Reference Table
- Oracle Provided Packages
DBMS_Alert
DBMS_Job
DBMS_Output
DBMS_Scheduler
UTL_File
UTL_Mail
Other Provided Packages
Day 3: Advanced Oracle PL/SQL:
- DBMS_SQL & Dynamic SQL
- Working with Large Objects
- Debugging PL/SQL Routines
- PL/SQL Profile
- Oracle Trace
- Working with Large Objects
- Debugging PL/SQL Routines
- PL/SQL Profile
- Oracle Trace
About Dan Hotka:
Dan Hotka is a Training Specialist who has over 30 years in the computer industry and over 25 years of experience with Oracle products. He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days. Dan’s latest book is the SQL Developer Handbook by Oracle Press. He is also the author of Oracle9i Development By Example and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world.