SQL is the key to getting work done with the Oracle database. This is true whether you are a database administrator or a developer. Yet few bother to master SQL as they should, and fewer still take the time to become intimately acquainted with the richness of SQL functionality that Oracle provides, which goes well beyond what many competing database vendors provide. In Mastering Oracle SQL, accomplished SQL experts Sanjay Mishra and Alan Beaulieu take you on a fast-paced and exciting tour of what Oracle has to offer when it comes to using SQL to write queries and manipulate data. You'll learn about the following areas in which Oracle truly excels. Oracle has excellent standards support; excellent support for temporal data, including time zones and interval types; partitioning features for very large databases; and PL/SQL for those times when SQL is still just not enough. If you work with Oracle, you can't afford not to learn all you can about what Oracle SQL has to offer.
1 Introduction to SQL
2 The WHERE Clause
3 Joins
4 Group Operations
5 Subqueries
6 Handling Temporal Data
7 Set Operations
8 Hierachical Queries
9 Decode and Cass
10 Partitioning
11 PL/SOL
12 Objects collections
ect.