| Oracle Advanced PL/SQL |
| |
| This hands-on course provides critical continuation of learning for the PL/SQL developer and is the next step for students with knowledge of the PL/SQL basics. This class is designed for PL/SQL developers writing or supporting complex enterprise systems. |
|
| Covered Topics: |
- PL/SQL review
- Oracle 9i PL/SQL new features overview
- Working with object types and methods
- PL/SQL records, tables and collections
- Table functions
- Overloading packages
- Built-in packages
- DBMS_SQL and execute immediate
- DBMS_LOB
- UTL_FILE
- DBMS_JOB
- DBMS_TRACE
- DBMS_PROFILER
|
| Prerequisites: |
- Oracle 9i SQL Fundamentals
- Oracle PL/SQL Fundamentals
- or equivalent experience
|
| Audience: |
|
Oracle application developers> |
|
| |
| Course Benefits: |
| Students will expand their knowledge of basic Oracle PL/SQL and be able to incorporate user defined datatypes (objects, records, tables, collections) and built-in packages when developing complex enterprise systems. |
| Materials Furnished: |
|
| Recommended Follow-On Course: |
- Oracle 9i Advanced SQL
- Oracle 9i Advanced PL/SQL
- Oracle Forms 9i
- Oracle Reports 9i
|
|
|
|
|
|
