Image
CERTIFICATION OBJECTIVES
12.01    Create Simple and Complex Views
12.02    Retrieve Data from Views
12.03    Create Private and Public Synonyms
12.04    Create, Maintain, and Use Sequences
12.05    Create and Maintain Indexes
  Image         Two-Minute Drill
Q&A      Self Test
 
So far, most of the SQL statements used in this book have addressed tables. This seems reasonable: SQL commands interact with data, and data is stored in tables. In practice, most users never issue SQL that addresses tables: they issue SQL that addresses views or synonyms. Views ...

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.