Loading Course Schedule...
PT3682
Training Summary
This hands-on class is designed for PL/SQL developers writing or supporting complex enterprise systems and provides a critical continuation of learning for the PL/SQL developer. This course is the next step for persons who have knowledge of PL/SQL basics.
Prerequisites
Students should have programming experience in PL/SQL and SQL.
Duration
3 Day/Lecture & Lab
Audience
This class is developed for application/software developers.
Course Topics
- Code the CASE statement
- Create DDL from existing database objects with DBMS_METADATA
- Incorporate date time data into your database and applications
- Build autonomous transactions
- Incorporate object-relational features into your applications
- Code pipelined table functions in Oracle9i databases
- Package your PL/SQL objects
- Use DBMS_LOB to process LOB data
- Use UTL_FILE to read and write to sequential files
- Schedule batch jobs with DBMS_JOB
- Communicate across Oracle sessions
- Use database-centric transaction-based messaging Understand the process of tuning and tracing PL/SQL programs
- PL/SQL Review
- PL/SQL New Features Overview
- Oracle Object Support
- PL/SQL Records, Tables and Collections
- Table Functions
- Advanced PL/SQL Package Practices
- Dynamic SQL
- LOB Handling Using DBMS_LOB
- File Input/Output Using UTL_FILE
- Schedule Batch Jobs Using DBMS_JOB
- Intersession Communication Using DBMS_PIPE and DBMS_ALERT
- Advanced Queuing using DBMS_AQ and DBMS_AQADM
- Tune and Trace PL/SQL Programs