Oracle SQL Revealed: Executing Business Logic in the Database Engine

Part I: Features and Theory.- .- 1. Joins.- 2. Query Transformations.- 3. Analytic Functions.- 4. Aggregate Functions.- 5. Hierarchical Queries: CONNECT BY.- 6. Recursive Subquery Factoring.- 7. Model.- 8. Row Pattern Matching: match_recognize.- 9. Logical Execution Order of Query Clauses.- 10. Turing Completeness.- .- Part II: PL/SQL and Patterns.- 11. When PL/SQL is Better.- 12. Solving SQL Quizzes.- Appendix A: Useful Oracle Links.