November 2008
Intermediate to advanced
591 pages
17h 28m
English
Oracle’s window function syntax is as follows:
FUNCTION_NAME(expr) OVER (window_clause)window_clause::= [partitioning] [ordering[framing]]partitioning::= PARTITION BYvalue[,value...]ordering::= ORDER [SIBLINGS] BYrule[,rule...]rule::= {value|position|alias} [ASC | DESC] [NULLS {FIRST | LAST}]framing::= {ROWS | RANGE} {not_range|beginANDend}not_range::= {UNBOUNDED PRECEDING | CURRENT ROW |valuePRECEDING}begin::= {UNBOUNDED PRECEDING | CURRENT ROW |value{PRECEDING | FOLLOWING}}end::= {UNBOUNDED FOLLOWING | CURRENT ROW |value{PRECEDING | FOLLOWING}}