OCA Oracle Database 11g SQL Fundamentals I Exam Guide

CERTIFICATION OBJECTIVES

3.01    Limit the Rows Retrieved by a Query

3.02    Sort the Rows Retrieved by a Query

3.03    Ampersand Substitution

        Two-Minute Drill

Q&A    Self Test

 

Limiting the columns retrieved by a SELECT statement is known as projection and was introduced in Chapter 2. Restricting the rows returned is known as selection. This chapter discusses the WHERE clause, which is an enhancement to the selection functionality of the SELECT statement. The WHERE clause specifies one or more conditions that the Oracle server evaluates ...