| |
Advanced PL/SQL
Assumptions and pre-requisites
Knowledge of the topics covered in our PL/SQL course
Course Outline
Scheduling Jobs
- Setting up the server processes.
- Using DBMS_JOB
- Submitting Jobs.
- Date Formats.
- The data dictionary and checking jobs status.
Advanced Queuing
- History Using DBMS_PIPE
- Aqadmin.
- Queue tables.
- Enqueue, Dequeue.
- Message/Meta data.
- The Data Dictionary.
PL/SQL Tuning
- The Shared Pool
- Pinning Objects in the shared pool
- Stats from lib cache on reuse.
- Network round trips and fetch size in client server environment.
- Avoiding reparsing.
LOBS
- Refresh of lob architecture.
- CLOB/BLOB
- Bfiles.
- Using DBMS_LOB
- Putting sound and images from file system into BLOBS.
- Pre Built form to display pictures and play sounds.
- Text processing using CLOBS.
- Very brief use of CLOBS with XML and inter media indexes
Objects and collection types
- Object Types, and inheritance in Oracle.
- Object Tables, Nested tables, and Varrays.
- Processing the above with PLSQL.
- Plsql methods.
- Order by and Map methods.
Processing XML with PLSQL
- Brief introduction to XML.
- The magic of XML- moving data easily between XML files and Oracle tables
- Using Bfiles to read XML into CLOBS.
- Install/Checking the XML toolkit.
- Parsing XML and Transforming XML
- Using the DOM API.
- Searching XML with XPATH
PL/SQL in the Web server
- Introduction to mod-plsql and Apache.
- Architecture of Dynamic Web pages using HTML tags within PLSQL.
- The Plsql web Tool kit.
External Procedures
- Architecture and setting up the server.
- Parameter Mapping.
- Security.
- Calling C dynamic libraries in Unix and Win32.
- Calling operating system functions eg copy/dir/format.
- Calling Java
Brief overview of some commonly used packages
- DBMS_OUTPUT in more detail
- UTL_FILE
- DBMS_DDL
- DBMS_RANDOM
- DBMS_PROFILER and DBMS_TRACE
[RETURN TO LIST OF COURSES]
|