OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

4

Restricting and Sorting Data

CERTIFICATION OBJECTIVES

4.01     Sort the Rows That Are Retrieved by a Query

4.02     Limit the Rows That Are Retrieved by a Query

4.03     Use Ampersand Substitution to Restrict and Sort Output at Run Time

4.04     Use the SQL Row Limiting Clause

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter looks at various capabilities of the SELECT statement: the WHERE clause, the ORDER BY clause, ampersand substitution, and the SQL row limiting clause. The ORDER BY clause sorts the retrieved rows. It’s very flexible: it can sort rows in ascending or descending order, or it can sort by expression lists or take ...