OCA/OCP: Introduction to Oracle9iTM SQL Study Guide

About this book

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:* In-depth coverage of official exam objectives* Practical information on using SQL in a real-world Oracle9i environment* Hundreds of challenging review questions, in the book and on the CDAuthoritative coverage of all exam objectives, including:* Writing basic SQL SELECT statements* Restricting and sorting data* Displaying data from multiple tables* Aggregating data using group functions* Producing readable output with iSQL*Plus* Creating and managing tables* Controlling user access