Oracle SQL by example

Foreword     xxxiPreface     xxxivChapter 1: SQL and Data     1Chapter 2: SQL: The Basics     49Chapter 3: The WHERE and ORDER BY Clauses     101Chapter 4: Character, Number, and Miscellaneous Functions     133Chapter 5: Date and Conversion Functions     189Chapter 6: Aggregate Functions, GROUP BY, and HAVING Clauses     263Chapter 7: Equijoins     285Chapter 8: Subqueries     323Chapter 9: Set Operators     377Chapter 10: Complex Joins     399Chapter 11: Insert, Update, and Delete     429Chapter 12: Create, Alter, and Drop Tables     503Chapter 13: Indexes, Sequences, and Views     571Chapter 14: The Data Dictionary, Scripting, and Reporting     615Chapter 15: Security     661Chapter 16: Regular Expressions and Hierarchical Queries     695Chapter 17: Exploring Data Warehousing Features     741Chapter 18: SQL Optimization     803Appendix A: Answers to Quiz Questions     839Appendix B: SQL Formatting Guide     855Appendix C: SQL*Plus Command Reference     859Appendix D: STUDENT Database Schema     873Appendix E: Table and Column Descriptions     875Appendix F: Additional Example Tables     881Appendix G: Navigating the Oracle Documentation     887Appendix H: Resources     893Appendix I: Oracle Data Types     897Index     899