Morton K. et al. Pro Oracle SQL

Apress, 2013. — 568 p. — 2nd ed. — ISBN: 9781430262206Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets.Core SQL
SQL Execution
Access and Join Methods
SQL is About Sets
It’s About the Question
SQL Execution Plans
Advanced Grouping
Analytic Functions
The Model Clause
Subquery Factoring
Semi-joins and Anti-joins
Indexes
Beyond the SELECT
Transaction Processing
Testing and Quality Assurance
Plan Stability
Plan Management/Control
Cool SQL Constructs