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.