SUMMARY:   This course provides the student with an in-depth look at PL/SQL in the SQL*Plus enviroment in order to create and use user defined packages, as well as being able to use Oracle supplied packages. This course also covers creation of Database Triggers. AUDIENCE:   Programmers and support staff who wish to gain a more comprehensive understanding of how the Oracle Procedural Level/Structured Query Language can be used in order to utilize Packages and Triggers. PREREQUISITES:   A good knowledge of SQL, SQL*Plus and the standard editor available on their target hardware platform. Understanding of Oracle PL/SQL programming concepts and techniques is also required. Previous attendance of our course Oracle10g PL/SQL Programming Part One is highly recommended. DURATION:   2 Days * Note:This course can be combined with our Oracle10g PL/SQL Part One course in order to form a single 5 day course. APPROACH:   This course is highly interactive and consists of theory coupled with plenty of hands-on practical sessions. OBJECTIVES:   On completion of the course, students will be able to write user defined Packages and Triggers, produce PL/SQL code that uses Oracle supplied Packages and create re-usable code with NDS. COURSE CONTENT:   PACKAGES INTRODUCTION PACKAGE STRUCTURE PACKAGE CREATION BUILT-IN PACKAGES INTRODUCTION STANDARD AND DBMS_STANDARD DBMS_ALERT DBMS_DDL DBMS_JOB DBMS_LOCK DBMS_PIPE DBMS_SESSION DBMS_SQL DBMS_TRANSACTION DBMS_UTILITY UTL_FILE ORACLE10g PACKAGES NATIVE DYNAMIC SQL (NDS) INTRODUCTION DBMS_SQL Vs. NDS NDS COMMANDS EXECUTE IMMEDIATE OPEN FOR (CURSOR VARIABLES) USING BIND VARIABLES WITH NDS DDL AND DATABASE LEVEL TRIGGERS DDL TRIGGERS DATABASE LEVEL TRIGGERS A LOGON TRIGGER COLLECTIONS INTRODUCTION DECLARING NESTED TABLES and VARRAYs INITIALISING COLLECTIONS MANIPULATING ELEMENTS COLLECTION METHODS BULK BINDS EXTERNAL PROCEDURES & JAVA INTEGRATION INTRODUCTION EXTERNAL PROCEDURES JAVA INTEGRATION PUBLISHING JAVA TO PL/SQL COLLECTION METHODS