When one thinks of the types of objects in a database, tables are the ones that most commonly spring to mind. However, there are many types of objects that can be created and stored in an Oracle database. They range from the tables that we have seen thus far to objects that can be used to speed performance or simplify queries. In this chapter, we examine a number of these objects and how they can be used within the Oracle database.
In this chapter, we shall: