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