PrefaceChapter 1: Introduction to SQLChapter 2: The WHERE ClauseChapter 3: JoinsChapter 4: Group OperationsChapter 5: SubqueriesChapter 6: Handling Temporal DataChapter 7: Set OperationsChapter 8: Hierarchical QueriesChapter 9: DECODE and CASEChapter 10: PartitioningChapter 11: PL/SQLChapter 12: Objects and CollectionsChapter 13: Advanced Group OperationsChapter 14: Advanced Analytic SQLChapter 15: SQL Best PracticesChapter 16: XMLChapter 17: Regular ExpressionsChapter 18: Model QueriesAppendix A: Oracle's Old Join SyntaxColophon