OCA Oracle Database 11g SQL Fundamentals I Exam Guide

CERTIFICATION OBJECTIVES

2.01    List the Capabilities of SQL SELECT Statements

2.02    Execute a Basic SELECT Statement

        Two-Minute Drill

Q&A    Self Test

 

This chapter explores the concepts of extracting or retrieving data stored in relational tables using the SELECT statement. The statement is introduced in its basic form and is progressively built on to extend its core functionality. As you learn the rules governing this statement, an important point to remember is that the SELECT statement never alters information stored in the database. ...