Oracle SQL by example /
Rischert, Alice
Oracle SQL by example / Alice Rischert. - Upper Saddle River, NJ : Prentice Hall, c2010. - xxxix, 913 p. : ill. ; 23 cm. - The Prentice Hall Oracle series .
Includes bibliographical references and index.
Chapter 1 : SQL and Data -- Chapter 2 : SQL : The Basics -- Chapter 3 : The WHERE and ORDER BY Clauses -- Chapter 4 : Character, Number, and Miscellaneous Functions -- Chapter 5 : Date and Conversion Functions -- Chapter 6 : Aggregate Functions, GROUP BY, and HAVING Clauses -- Chapter 7 : Equijoins -- Chapter 8 : Subqueries -- Chapter 9 : Set Operators -- Chapter 10 : Complex Joins -- Chapter 11 : Insert, Update, and Delete -- Chapter 12 : Create, Alter, and Drop Tables -- Chapter 13 : Indexes, Sequences, and Views -- Chapter 14 : The Data Dictionary, Scripting and Reporting -- Chapter 15 : Security -- Chapter 16 : Regular Expressions and Hierarchical Queries -- Chapter 17 : Exploring Data Warehousing Features -- Chapter 18 : SQL Optimization.
“The book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book many times over.” –Dr. Paul Dorsey, President, Dulcian, Inc., Oracle Magazine PL/SQL Developer of the Year 2007, and President Emeritus, New York Oracle Users Group “This is a fascinating guide into the world of Oracle SQL with an abundance of well-collected examples. Without a doubt, this book is helpful to beginners and experts alike who seek alternative ways to resolve advanced scenarios.”–Oleg Voskoboynikov, Ph.D., Database Architect
9780137142835 (pbk. : alk. paper) 0137142838 (pbk. : alk. paper)
2009022733
Oracle (Computer file)
SQL (Computer program language)
005.133
Oracle SQL by example / Alice Rischert. - Upper Saddle River, NJ : Prentice Hall, c2010. - xxxix, 913 p. : ill. ; 23 cm. - The Prentice Hall Oracle series .
Includes bibliographical references and index.
Chapter 1 : SQL and Data -- Chapter 2 : SQL : The Basics -- Chapter 3 : The WHERE and ORDER BY Clauses -- Chapter 4 : Character, Number, and Miscellaneous Functions -- Chapter 5 : Date and Conversion Functions -- Chapter 6 : Aggregate Functions, GROUP BY, and HAVING Clauses -- Chapter 7 : Equijoins -- Chapter 8 : Subqueries -- Chapter 9 : Set Operators -- Chapter 10 : Complex Joins -- Chapter 11 : Insert, Update, and Delete -- Chapter 12 : Create, Alter, and Drop Tables -- Chapter 13 : Indexes, Sequences, and Views -- Chapter 14 : The Data Dictionary, Scripting and Reporting -- Chapter 15 : Security -- Chapter 16 : Regular Expressions and Hierarchical Queries -- Chapter 17 : Exploring Data Warehousing Features -- Chapter 18 : SQL Optimization.
“The book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book many times over.” –Dr. Paul Dorsey, President, Dulcian, Inc., Oracle Magazine PL/SQL Developer of the Year 2007, and President Emeritus, New York Oracle Users Group “This is a fascinating guide into the world of Oracle SQL with an abundance of well-collected examples. Without a doubt, this book is helpful to beginners and experts alike who seek alternative ways to resolve advanced scenarios.”–Oleg Voskoboynikov, Ph.D., Database Architect
9780137142835 (pbk. : alk. paper) 0137142838 (pbk. : alk. paper)
2009022733
Oracle (Computer file)
SQL (Computer program language)
005.133