OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition

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