In this chapter, we've added two major skills to our growing list of SQL capabilities: selectivity and the ability to sort data. We've examined the structure of both the
WHERE clause and the
BY clause. We've looked at a large number of condition types that can be used with the
WHERE clause, including equality, non-equality, and Boolean conditions. We've explored conditions that require additional clauses, such as range, set, and list conditions. We've examined how Oracle utilizes pattern-matching and substitution variables to create open-ended conditions. Finally, we've worked with different ways to sort our resulting sets of data.