Oracle SQL by Example 4th Edition

Description

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

g

g, today's #1 database platform - not generic SQL!
*
*
*
*
*
*
* g's advanced data warehousing features
*
*
* For every database developer, administrator, designer, or architect, regardless of experience!

CONTENTS:

Foreword xxxi

Preface xxxiv

Chapter 1: SQL and Data 1

Chapter 2: SQL: The Basics 49

Chapter 3: The WHERE and ORDER BY Clauses 101

Chapter 4: Character, Number, and Miscellaneous Functions 133

Chapter 5: Date and Conversion Functions 189

Chapter 6: Aggregate Functions, GROUP BY, and HAVING Clauses 263

Chapter 7: Equijoins 285

Chapter 8: Subqueries 323

Chapter 9: Set Operators 377

Chapter 10: Complex Joins 399

Chapter 11: Insert, Update, and Delete 429

Chapter 12: Create, Alter, and Drop Tables 503

Chapter 13: Indexes, Sequences, and Views 571

Chapter 14: The Data Dictionary, Scripting, and Reporting 615

Chapter 15: Security 661

Chapter 16: Regular Expressions and Hierarchical Queries 695

Chapter 17: Exploring Data Warehousing Features 741

Chapter 18: SQL Optimization 803

Appendix A: Answers to Quiz Questions 839

Appendix B: SQL Formatting Guide 855

Appendix C: SQL*Plus Command Reference 859

Appendix D: STUDENT Database Schema 873

Appendix E: Table and Column Descriptions 875

Appendix F: Additional Example Tables 881

Appendix G: Navigating the Oracle Documentation 887

Appendix H: Resources 893

Appendix I: Oracle Data Types 897

Index 899