|
Chapter 1: Oracle SQL Query overview
- Syntax
- Subqueries
- Joins
- Sets
Chapter 2:
Oracle SQL Functions
- Standard functions
Compare dates, evaluate conditions in CASE and LNNVL,
convert and cast, check for nulls, use regular expressions
Chapter 3: Oracle SQL Aggregation
- Standard functions
Sum, count and calculate averages. Nest aggregates function
- Grouping sets
Create totals, sub-totals, grand-totals
- Pivot functions
Chapter 4: Oracle SQL Analytics
- Syntax
- Window
Calculate cumulative totals, moving windows
- Order
Number rows with row_number, rank and dense_rank
- Inter-rows calculation
Access rows with lead, lag, first_value and last_value
- Analytic
functions
Percentage and statistics
|
|
Chapter 5: XML
- XML functions
Use Oracle functions to convert XML from and to relational
data
- XPATH
Extract values from an XML document
- Aggregation
Use XMLAGG to perform aggregation
- XQuery
Use XQUERY and XMLTABLE to write XQuery programs and to
access XML and relational data
Chapter 6: Oracle SQL Hierarchies
- Syntax
- Loops
Prevent ORA-01436 with the NOCYCLE keyword. Detect loops
with the CONNECT_BY_ISCYCLE function
- First ancestor
Aggregate hierarchical results with CONNECT_BY_ROOT
- Paths
Retrieve the full path with SYS_CONNECT_BY_PATH
Chapter 7: Oracle SQL Model Clause
- Syntax
- Inter-rows calculation
Access and update a row, retrieve any values from the result
set
- Iterate
Loop and generate new rows
Appendix – SQL*Plus
Create scripts for
Unix
and Windows to retrieve the results of SELECT queries
|
