O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

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

Summary

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

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