Index
A
Adjacency lists model
Aggregate functions
atomic type result
Cartesian join
collect function
concatenate collection elements
cube
definition
EAV model
grouping and grouping_id
parsing pivot XML
rollup
UDAG
unpivot operator
Analytic functions
aggregate functions
avoiding joins
definition
differences and interchangeability
max date
max value partition
unbounded range
fetch termination
PL/SQL function
recursive subquery factoring
row_number
sum
transaction
types and function
vs.
joins
approaches
execution plans
last_value and ignore nulls
limitations
listagg and stragg
logic implementation
order by
partition by part
query rewriting
ANSI joins
Cloudera Impala
cross join
demonstration tables
full outer join
inner join
equality condition
non-equality predicate
left outer join
limitations ...
Get Oracle SQL Revealed: Executing Business Logic in the Database Engine now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
