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
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 ...
Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
