SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK ORACLE SQL REVEALED
SUMMARY
-
Items Found: 75
- Part I: Features and Theory 1
- Chapter 1: Joins 5
- ANSI Joins 6
- Other Types of Joins 10
- Oracle-Specific Syntax 15
- ANSI vs. Oracle Native Syntax 23
- Limitation of the Oracle Native Syntax 23
- Unnesting Collections 36
- Correlated Inline Views and Subqueries 39
- ANSI to Native Transformation 43
- Clearness and Readability 52
- Mixing Syntax 56
- Controlling Execution Plan 60
- Limitations of ANSI 61
- Summary 65
- Chapter 2: Query Transformations 67
- Summary 82
- About the Author vii
- Introduction ix
- Chapter 3: Analytic Functions 85
- Differences and Interchangeability of Functions 98
- Summary 102
- Chapter 4: Aggregate Functions 103
- Pivot and Unpivot Operators 110
- Cube, Rollup, Grouping Sets 113
- Summary 118
- Chapter 5: Hierarchical Queries: Connect by 119
- Pseudocolumn Generation in Detail 135
- Summary 138
- Chapter 6: Recursive Subquery Factoring 139
- Traversing Hierarchies 146
- Once Again About Cycles 151
- Limitations of the Current Implementation 156
- Summary 158
- Chapter 7: Model 161
- Brief Analysis of the Performance 187
- Model Parallel Execution 193
- Summary 197
- Chapter 8: Row Pattern Matching: match_recognize 199
- Summary 216
- Chapter 9: Logical Execution Order of Query Clauses 217
- Summary 233
- Chapter 10: Turing Completeness 235
- Summary 242
- Part II: PL/SQL and SQL solutions 243
- Chapter 11: When PL/SQL Is Better Than Vanilla SQL 245
- Specifics of Analytic Functions 246
- Fetch Termination 246
- Avoiding Multiple Sorts 264
- Iterative-Like Computations 272
- When There Is No Effective Built-In Access Method 273
- Problems of a Combinatorial Nature 279
- Specifics of Joins and Subqueries 287
- Specifics of Joins 288
- Limitations of the Subqueries 299
- Summary 303
- Chapter 12: Solving SQL Quizzes 305
- Converting into Decimal Numeral System 305
- Connected Components 308
- Ordering Dependencies 314
- Percentile with Shift 320
- N Consequent 1s 325
- Next Value 328
- Next Branch 332
- Random Subset 342
- Covering Ranges 347
- Zeckendorf Representation 349
- Top Paths 356
- Resemblance Group 362
- Baskets 367
- Longest Increasing Subsequence 372
- Quine 377
- Summary 378
- Appendix A: Useful Oracle Links 381
- Index 383
