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
3.01    Limit the Rows Retrieved by a Query
3.02    Sort the Rows Retrieved by a Query
3.03    Ampersand Substitution
  Image      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 ...

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