Practical Oracle SQL

 

 

저자 샘플 보기

http://nocoug.org/Journal/NoCOUG_Journal_202002.pdf#page=4

 

Mastering the Full Power of Oracle Database

Authors: Berg Hansen, Kim

 

Table of contents (22 chapters)

Correlating Inline Views 3-16

Pitfalls of Set Operations 17-38

Divide and Conquer with Subquery Factoring 39-56

Tree Calculations with Recursion 57-71

Functions Defined Within SQL 73-85

Iterative Calculations with Multidimensional Data 87-106

Unpivoting Columns to Rows 107-129

Pivoting Rows to Columns 131-144

Splitting Delimited Text 145-168

Creating Delimited Text 169-190

Analytic Partitions, Ordering, and Windows 193-213

Answering Top-N Questions 215-235

Ordered Subsets with Rolling Sums 237-265

Analyzing Activity Logs with Lead 267-286

Forecasting with Linear Regression 287-305

Rolling Sums to Forecast Reaching Minimums 307-322

Up-and-Down Patterns 325-349

Grouping Data Through Patterns 351-369

Merging Date Ranges 371-388

Finding Abnormal Peaks 389-410

Bin Fitting 411-434

Counting Children in Trees 435-451