How apress/practical-oracle-sql works
This repository is a companion collection of Oracle SQL examples for *Practical Oracle SQL*. Its conceptual workflow is to prepare the practical schema, then study chapter examples covering SQL decomposition and recursion, reshaping and text, analytic queries, and pattern-oriented problems. The schema scripts and chapter files are represented as distinct components; the supplied README confirms the companion-book role but gives no execution or call relationships. No source excerpts were provided, so edges between components are omitted rather than inferred.
Components 26
Practical Schema
- Create schema
practical_create_schema.sql - Fill schema
practical_fill_schema.sql - Clean schema
practical_clean_schema.sql - Drop schema
practical_drop_schema.sql
SQL Foundations
- Correlating inline views
Chapter 1/ch01_correlating_inline_views.sql - Set operation pitfalls
Chapter 2/ch02_pitfalls_of_set_operations.sql - Subquery factoring
Chapter 3/ch03_divide_and_conquer_with_subquery_factoring.sql - Recursive tree calculations
Chapter 4/ch04_tree_calculations_with_recursion.sql - SQL-defined functions
Chapter 5/ch05_functions_defined_within_sql.sql - Multidimensional iteration
Chapter 6/ch06_iterative_calculations_with_multidimensional_data.sql
Reshaping and Text
- Unpivot columns
Chapter 7/ch07_unpivoting_columns_to_rows.sql - Pivot rows
Chapter 8/ch08_pivoting_rows_to_columns.sql - Split delimited text
Chapter 9/ch09_splitting_delimited_text.sql - Create delimited text
Chapter 10/ch10_creating_delimited_text.sql
Analytic SQL
- Analytic windows
Chapter 11/ch11_analytic_partitions_ordering_and_windows.sql - Top-N queries
Chapter 12/ch12_answering_top_n_questions.sql - Rolling sums
Chapter 13/ch13_ordered_subsets_with_rolling_sums.sql - Activity log analysis
Chapter 14/ch14_analyzing_activity_logs_with_lead.sql - Linear regression forecast
Chapter 15/ch15_forecasting_with_linear_regression.sql - Forecast minimums
Chapter 16/ch16_rolling_sums_to_forecast_reaching_minimums.sql - Up-down patterns
Chapter 17/ch17_up_and_down_patterns.sql - Pattern grouping
Chapter 18/ch18_grouping_data_with_patterns.sql
Patterns and Models
- Merge date ranges
Chapter 19/ch19_merging_date_ranges.sql - Abnormal peaks
Chapter 20/ch20_finding_abnormal_peaks.sql - Bin fitting
Chapter 21/ch21_bin_fitting.sql - Count tree children
Chapter 22/ch22_counting_children_in_trees.sql