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

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.