2 Basic Components of Oracle Objects

The basic components of Oracle Objects are object types, subprograms, and the hierarchy of object types.

Basic information about working with Oracle SQL objects includes what object types and subprograms are, and how to create and work with a hierarchy of object types that are derived from a shared root type and are connected by inheritance.

Note:

Running Examples: In order to run examples in chapter 2, you may need to drop any objects you created for Chapter 1.

Topics:

• SQL Object Types and References

• Object Methods

• Inheritance in SQL Object Types

• Functions and Operators Useful with Objects