CRITICAL SKILL 2.3
Use Simple where Clauses
Up to now, you have seen how the select command can be used to retrieve records from a table. However, our basic examples have all retrieved every record from the table. If you want to see only certain rows, you must add a where clause.
Since our previous examples returned every record in the table, we created a simple table with a few rows in it for illustration purposes. Had we chosen to illustrate the select command against the large sample tables provided by Oracle, we would have returned thousands of rows—far too many for listing in this chapter. Now that we are introducing the where clause, we will be able to control the output. As a result, the remaining examples in this chapter will now use ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
