O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) by Roopesh Ramklass, John Watson

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

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 ...

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