Binding: Paperback Dewey Decimal Number: 005.133 EAN: 9780072229813 ISBN: 0072229810 Label: McGraw-Hill Osborne Media Manufacturer: McGraw-Hill Osborne Media Number Of Items: 1 Number Of Pages: 608 Publication Date: February 20, 2004 Publisher: McGraw-Hill Osborne Media Sales Rank: 124384 Studio: McGraw-Hill Osborne Media
Product DescriptionThis volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.
What Others Say
Almost makes it
Maybe a little disorganized, but overall a pretty good reference. Lots of odd omissions though. For instance, the SUBSTR function can take negative number parameters but that is not shown. In the numeric functions, where are the GREATEST and LEAST functions? There is a list of conversion functions but no examples. If you've ever pulled your hair out over a deeply nested DECODE, you know some good examples would be nice. A few of the SQL*Plus SET commands are scattered here and there, but there is no list.
Bottom line... not bad but needs more work.
Good coverage of concepts but with no exercises for the reader to practice
Oracle Database 10g SQL - Is a good book to read or reference concepts in detail. Author has covered good amount of concepts from basics of SQL to advanced SQL queries. But we were disappointed to find that the book doesn't come with exercises at the end of each chapter to practice and play on the concepts understood.
Good book from scratch to practice
It is a very good book for both who are beginning to learn SQL from scratch or those who are not too familiar with Oracle SQL databases. It introduces a lot of new 10g functionalities. Examples are given in almost most functions for easy understanding of practical usage. However, the book does not explain enough about the concept of storage about the Oracle 10g.
It is a good book for beginners
The book is good for beginners, especially who do not know SQL. The book talked about basic SQL syntax, and SQL Plus at the beginning. It also covers advanced SQL at the second part which I just ignored.
In the w'abbit warren with Alice in Wonderland
The disorganization of topics is staggering. It covers a number of useful aspects about using Oracle SQL, but it fails to develop complete ideas. It can serve as a quick reference to moderately skilled programmers but so can the Oracle docs.
Beginners may wish to try Learning SQL by Alan Beaulieu, and intemediates are better off with Oracle by Example by Alice Rischert, alas old hack are still looking for a book.
Good Points:
- Identifies the deference between ANSI/86 and ANSI/92, albeit in an indexed note on page #46. An improvement over labeling ANSI/86 as Oracle Proprietary syntax like another author does in a competing book.
- SQL*Plus does show how to set a default editor.
- Nice coverage of ROLLUP, ... Read More
