Module 17 - Oracle Compatibility

Module Objectives

Oracle Compatibility

Oracle Compatible Tools

Oracle Compatibility Settings

Example - Oracle Compatibility Settings

Oracle Compatibility - Data Types

Oracle Compatibility - Synonyms

Dual Table

Oracle Compatibility - Altering Session Parameters

Oracle Compatibility - Create Directory

Hierarchical Queries

Oracle Compatible Connect By

Table Partitioning

Stored Procedure Language

Built-in Packages

System Catalog Views

sys Schema

ECPGPlus

Open Client Library(OCL)

Other Oracle Compatibilities

Module Summary

Lab Exercise

Lab Exercise (continued)