TECHNICAL REQUIREMENTS FOR CLASS SETUP

PC-equipped classroom with SQL/PLUS installed on student PCs. Barco projector to display instructor?s PC.

Note: Client will need a technical person to install class tables on a non-production database server, client product on student/instructor PCs, and client class files. Check install and call instructor to verify all set five days prior to class.

LOCATION AND MAXIMUM ATTENDANCE

All classes are scheduled and held at client site training rooms. No minimum attendance requirement. Maximum number of students: 16.

CONTENTS

• Overview and understand all PL/SQL program constructs: Procedures, Functions, Packages, Triggers. Understand development environments: SQL/PLUS, Procedure Builder.
• Create stored (database) procedures and learn parameter modes IN, OUT, and IN OUT. Call procedures from anonymous blocks and from SQL/PLUS environment. Create a client-side procedure.
• Create stored functions; learn parameter usages and the RETURN statement. Call functions from SQL statements, SQL/PLUS, and from procedures. Calling functions in expressions.
• Create packages. Reference global variables declared in packages. Persistent state of package constructs. Managing and calling multiple procedures and functions in packages.
• Learn about database triggers using before and after statements, insert, update, and delete styles. Use conditional predicates, and OLD/NEW Qualifiers. Learn to enhance table security with triggers, create audit tables, and understand mutating tables.
• Managing code through data-dictionary access. Tables include USER_SOURCE, USER_TRIGGERS, USER_OBJECTS. Understanding dependencies. Use built-in packages for debugging.
• Working with Oracle 8i Objects, Object Types, and new Large Object datatypes.