And insert retrieving changes with pipelined dml chapter recursive queries
| Table of Contents | ix |
|---|
WHERE Clauses ............................................................................................213 Comparison predicates .....................................................................215 BETWEEN ............................................................................................215 IN and NOT IN .....................................................................................217 LIKE and NOT LIKE ............................................................................218 SIMILAR ...............................................................................................220 NULL ....................................................................................................220 ALL, SOME, ANY .................................................................................221 EXISTS .................................................................................................224 UNIQUE ................................................................................................225 DISTINCT .............................................................................................225 OVERLAPS ...........................................................................................226 MATCH ................................................................................................226 Referential integrity rules and the MATCH predicate .......................228 Logical Connectives ....................................................................................230 AND ......................................................................................................230 OR ........................................................................................................231 NOT ......................................................................................................232 GROUP BY Clauses ......................................................................................232 HAVING Clauses ...........................................................................................234 ORDER BY Clauses ......................................................................................235 Limited FETCH .............................................................................................236 Peering through a Window to Create a Result Set ..................................238 Partitioning a window into buckets with NTILE ............................239 Navigating within a window .............................................................239 Nesting window functions ...............................................................241 Evaluating groups of rows ................................................................242
Chapter 11: Using Relational Operators . . . . . . . . . . . . . . . . . . . . . . . . .243
| x |
|---|
Chapter 13: Recursive Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .285
What Is Recursion? ......................................................................................285 Houston, we have a problem ............................................................287 Failure is not an option .....................................................................287 What Is a Recursive Query? .......................................................................288 Where Might You Use a Recursive Query? ...............................................289 Querying the hard way ......................................................................290 Saving time with a recursive query .................................................291 Where Else Might You Use a Recursive Query? ......................................293
