Mastering Oracle SQL, 2nd Edition
| Author | : | |
| Rating | : | 4.91 (810 Votes) |
| Asin | : | 0596006322 |
| Format Type | : | paperback |
| Number of Pages | : | 496 Pages |
| Publish Date | : | 2016-10-13 |
| Language | : | English |
DESCRIPTION:
Four Stars Great reference book!. Paid for itself in 10 minutes M. McLeod A clear explaination of how to use multiple nested views has saved the day. I can now run a single query on my large table (the table has 83 Million rows in it) and it completes by in a few hours. I have enjoyed reading it and becoming more experienced in SQL. In the past I would use Perl/DBI to access the database but now I do it through sqlplus because of the large datasets I a. Tracy Kingsley said What can you do with Oracle SQL?. Half of this What can you do with Oracle SQL? Tracy Kingsley Half of this 450 page book surveys basic SQL, and the other half is on features Oracle added to SQL in versions 9i and especially 10g. I bought the book because I believed the title, and the reviews here that said it was an excellent reference. But, to quote one of its authors, "This book is NOT a reference manual, and it is NOT an administrator's guide". It's an overview of SQL . 50 page book surveys basic SQL, and the other half is on features Oracle added to SQL in versions 9i and especially 10g. I bought the book because I believed the title, and the reviews here that said it was an excellent reference. But, to quote one of its authors, "This book is NOT a reference manual, and it is NOT an administrator's guide". It's an overview of SQL
About the AuthorSanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He has been involved in the design, architecture, and implementation of many mission-critical and decision support data
Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at sanjay_mishra@i2.. Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He has worked extensively in the area
But if you use Oracle SQL on a regular basis, you want much more. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap betwee