TY - BOOK AU - Rischert,Alice TI - Oracle SQL by example / T2 - The Prentice Hall Oracle series SN - 9780137142835 (pbk. : alk. paper) U1 - 005.133 22 PY - 2010/// CY - Upper Saddle River, NJ : PB - Prentice Hall, KW - Oracle (Computer file) KW - SQL (Computer program language) N1 - 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 N2 - “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 ER -