Книга "Practical Oracle SQL. Mastering the Full Power of Oracle Database". Part I. Core SQL1. Correlating Inline Views2. Pitfalls of Set Operations3. Divide and Conquer with Subquery Factoring4. Tree Calculations with Recursion5. Functions Defined Within SQL6. Iterative Calculations with Multidimensional Data7. Unpivoting Columns to Rows8. Pivoting Rows to Columns9. Splitting Delimited Text10. Creating Delimited TextPart II. Analytic Functions11. Analytic Partitions, Ordering and Windows12. Answering Top-N Questions13. Ordered Subsets with Rolling Sums14. Analyzing Activity Logs with Lead15. Forecasting with Linear Regression16. Rolling Sums to Forecast Reaching MinimumsPart III. Row Pattern Matching17. Up and Down Patterns18. Grouping Data Through Patterns19. Merging Date Ranges20. Finding Abnormal Peaks21. Bin Fitting22. Counting Children in Trees