If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.This book shows you how to:
Leverage Oracle's vast library of built-in SQL functions
Query time-based data, and write joins involving date and time ranges
Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format
Use DECODE and CASE to implement conditional logic in your queries
Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
Join data from two or more tables using the newly supported SQL92 join syntax
In addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.Precious few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that, showing you how to creatively leverage the full power of SQL to write queries in an Oracle environment.
Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at firstname.lastname@example.org.
Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at email@example.com.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The insect on the cover of Mastering Oracle SQL is a lantern fly. The lantern fly is mostly tropical, with a wingspan of up to six inches. The lantern fly's elongated head is an evolutionary adaptation called automimicry, in which parts of the body are disguised or artifically shifted to other areas to confuse predators: the lantern fly's head looks like a tail, and its tail looks like a head. On the rear it has artificial eyes and antennae. Colleen Gorman was the production editor and copyeditor for Mastering Oracle SQL. Sheryl Avruch and Ann Schirmer provided quality control. Tom Dinse wrote the index.Ellie Volckhausen and Emma Colby designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from Johnson's Natural History. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.David Futato designed the interior layout. Neil Walls converted the files from Microsoft Word to FrameMaker 5.5.6 using tools written in Perl by Erik Ray, Jason McIntosh, and Neil Walls, as well as tools written by Mike Sierra. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was written by Colleen Gorman.
Hi everyone, Please Notice that the examples for this book u can download @ http://shop.oreilly.com/product/9780596001292.On the Middle Right u can find the Essential links where u can download the examples/ Full Code mentioned for this Book.
Bottom Line No, I would not recommend this to a friend
Mastering Oracle SQL by Sanjay Mishra and Alan Beaulieu published by O'Reilly is a great book for exploring the intricacies of Oracle SQL and particularly version 9ias as it relates to the SQL92 standard. SQL is not a glamorous programming language, but the authors make it accessible without talking down to their intended audience or presenting examples that are too simplistic. Like all O'Reilly books, the material is well presented, the authors can program as well as write, and the book has a very consistent and pleasing look.
The first chapters are introductory and review material. There is a short section on the history of SQL along with a bit of theory regarding relational database management systems. This section covers the basic DML statements, the WHERE clause, joins, group functions, subqueries, date formatting and date manipulation. This is what I would define as the heart of SQL, and the tools that most SQL programmers use every day. The chapters follow a basic formula: the topic is presented using traditional Oracle SQL, and then presented again using the newer adherence to the ANSI SQL92 standard. The two methods are compared and contrasted.
The next section is about getting the best from SQL. Presented in these chapters are set operations, hierarchical queries, partitions, objects and collections. This section is more focused to the newer versions of the ORACLE RDBMS. Programmers still using the older versions will find fewer things they can actually use, but this section does a good job of taking the reader beyond what they have encountered in school or training classes.
I was surprised to see a chapter on PL/SQL, the procedural extension of SQL; a subject large enough for complete books, and a language with its own intricacies and gotchas. As the focus is on SQL this chapter shows how PL/SQL and SQL interact, rather than delving deeply into PL/SQL.
The chapter that interested me the most was 14: Best Practices. A constant challenge facing many SQL programmers is finding ways to write code that is faster. This chapter does a good job of explaining why certain SQL statements execute faster than others, resulting in large increases in efficiency.
This is a very good book for SQL users who use the latest versions of ORACLE products at work, and want to start out creating the best possible SQL code right away. The time spent reading this book is very rewarding, and can be applied immediately to business situations encountered every day.
A very good read, packed with good examples. However, we need scripts to create the tables used in all those wonderful examples -- how else are we to practice what we've just learned? Those scripts should be made available online.
I purchased ‘Mastering Oracle SQL' two weeks ago. Having worked with Oracle for the past six years, I found the book an excellent guide to reinforce my SQL knowledge. The book details various SQL functions etc. in detail and would highly recommend it to anyone presently working with Oracle SQL or entering the world of Oracle. ‘Mastering Oracle SQL' really gives you value for money. Unfortunately, unlike other books that I have purchased on Oracle, the scripts to create the tables which is useful to newcomers who want to practice code used in the book or sample code from the book is not available from the authors or the publishers web site. This is the only downside of the book.
Excellent, excellent, excellent! For an experienced SQL programmer, a delight to read. Even a few ideas not easily found elsewhere, can make a difference. Emphasis on inline views alone worth the price of book.
Gently introduces terms like "anti-join" in a very practical context, making them uniquely understandable.
Lack of coverage of MERGE ("UPSERT") statement, new in 9i, deplorable; it is useful not just in data warehousing.
And here's a trick from me: to insert a record without error if it already exists,
This is the best book for learning the SQL. It clears all the doubts that you have regarding the SQL queries and it can really be like a ready reference. Lots of examples make this book a very nice companion for the developers.
A Must Buy for all who are enthusiastic for learning good SQL concepts.