101 SQL FAQ
This book assembles in one convenient location the most common problems people encounter when using SQL and SQL*Plus to do ad hoc queries of Oracle databases. It is structured around specific questions and includes extensive cross-references to related material, making it useful to query writers of all levels of sophistication. Oracle SQL is based on a review of postings made to online Oracle discussion groups over a period of more than 2 years, so the questions appearing in the book are actual problems faced by real people doing their jobs.
Note: The publication date is 1997, so some of the material is dated. But the many annotated examples and answers to many of the questions should still be helpful. Enjoy.
Download entire book (5.1M)
Oracle SQL: 101 Frequently Asked Questions
Download individual sections
Front Sections
Title Page
Copyright
Dedication
Contents Summary
Contents
Preface
Acknowledgments
Chapters
1: Preliminaries
2: Building Blocks
3: Functions
4: Select Command
5: Special Problems
6: Reports
7: Utilities
8: Statistics
9: Performance
10: Interesting Queries
Back Sections
Appendix A: SQL Scripts
References
Index