O'Reilly logo

Oracle SQL Revealed: Executing Business Logic in the Database Engine by Alex Reprintsev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required