O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

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

10Creating Other Schema Objects

CERTIFICATION OBJECTIVES

10.01 Create and Use Simple and Complex Views

10.02 Create, Maintain, and Use Sequences

10.03 Create and Maintain Indexes

10.04 Create Private and Public Synonyms

Image Two-Minute Drill

Q&A Self Test

This chapter introduces a number of other schema objects that are necessary to understand in order to create a complete application. These objects include the view, sequence, index, and synonym. Each is uniquely important in a variety of ways.

CERTIFICATION OBJECTIVE 10.01Create and Use Simple and Complex Views

A view is a SELECT statement with a name, stored in the database, and accessible as though ...

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