O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Creating Other Database Objects

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:

  • Discuss the types of indexing available in Oracle
  • Examine the syntax of CREATE INDEX
  • Understand the use of views and their syntax
  • Look at how sequences are used to generate key values
  • Examine public and private synonyms

Using indexes to increase performance ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required