In one convenient resource, Gary Lewis and Alex Sirota have assembled solutions to the most common problems people encounter when using SQL, SQL*Plus, and PL/SQL to query Oracle databases. Structured around specific questions and including extensive cross-references to related material, this book can be used by query writers of all levels of sophistication. In preparing the book, the authors reviewed over three years of postings made to online Oracle discussion groups. The questions appearing in Oracle SQL are actual questions faced by people doing their jobs.
Book Description
Editorial Reviews
From the Publisher
Have you ever wondered how to solve any of these ad hoc query problems?
How can I do a top N report?
How do I identify join problems?
How do I prepare a traditional cross-tabulated report?
How do I determine due dates and account for holidays?
How do I make queries easier to construct?
How can I do an outer join to a subquery?
How do I randomly sample rows?
How can I do a percentage distribution report?
How do I recode numeric data into categories for frequency reports?
How do I create an address hierarchy?
How can I do a sorted INSERT?
When does a GROUP BY also ORDER BY?
How do I find rows that fell through a join?
Are there alternatives to correlated subqueries?
How do I sort a hierarchical query?
How do I block a report?
How do I find the median?
How can I do a running total report?
How do I build custom headers?
Among functionally equivalent queries, which one runs fastest?
How can I do a top N report?
How do I identify join problems?
How do I prepare a traditional cross-tabulated report?
How do I determine due dates and account for holidays?
How do I make queries easier to construct?
How can I do an outer join to a subquery?
How do I randomly sample rows?
How can I do a percentage distribution report?
How do I recode numeric data into categories for frequency reports?
How do I create an address hierarchy?
How can I do a sorted INSERT?
When does a GROUP BY also ORDER BY?
How do I find rows that fell through a join?
Are there alternatives to correlated subqueries?
How do I sort a hierarchical query?
How do I block a report?
How do I find the median?
How can I do a running total report?
How do I build custom headers?
Among functionally equivalent queries, which one runs fastest?
Oracle SQL answers these and more than 100 other common problems that people encounter when using SQL, SQL*Plus, and PL/SQL to query Oracle databases.
From the Author
Oracle SQL includes several special features that make it easy to use:
1. A question and answer format.
2. Emphasis on multiple approaches and answers to questions.
3. Extensive use of figures to illustrate query problems and solutions.
4. Figures keyed to comments in the text.
5. Cross-references to related material found elsewhere in the book.
6. Performance comparisons whenever multiple solutions to a question occur.
7. An appendix with complete program listings for many helpful utilities.
1. A question and answer format.
2. Emphasis on multiple approaches and answers to questions.
3. Extensive use of figures to illustrate query problems and solutions.
4. Figures keyed to comments in the text.
5. Cross-references to related material found elsewhere in the book.
6. Performance comparisons whenever multiple solutions to a question occur.
7. An appendix with complete program listings for many helpful utilities.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
5 of 5 people found the following review helpful:
5.0 out of 5 stars
WOW! QUERY FROM A QUERY INSTEAD OF A TABLE,
By jennifer.brickner@laspbs.state.fl.us (tallahassee, FL) - See all my reviews
This review is from: Oracle SQL: 101 Frequently Asked Questions (Paperback)
It has some real jewels in here, even for a VERY experienced programmer. How to change the SQL prompt, compute all kinds of statistics, including MEDIAN very quickly. Worth $30.
1 of 1 people found the following review helpful:
5.0 out of 5 stars
You will love it,
By
Amazon Verified Purchase(What's this?)
This review is from: Oracle SQL: 101 Frequently Asked Questions (Paperback)
This is the most used book in our IT department. Even experienced SQL programmers have found some tricks that were useful.This is not a SQL tutorial or reference. It is a list of frequently ask questions about Oracle SQL and one or more solutions to the same. All of the topics are logically grouped and clearly written. I HIGHLY recommend this book to anyone who writes SQL code more than occaisionally.
0 of 3 people found the following review helpful:
5.0 out of 5 stars
Good Book !,
By Vizkid (USA) - See all my reviews
This review is from: Oracle SQL: 101 Frequently Asked Questions (Paperback)
Gives good insight into SQL queries. Worth reading.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
