Oracle PL/SQL/Analytical Functions

• Aggregrate Analytical
• Analytical Functions Basics
• COVAR_POP
• COVAR_SAMP
• CUME_DIST
• CURRENTV
• Centered Average
• Compute
• Corr
• Cube
• Cumulative Sum
• DENSE_RANK
• First Last
• First Last Value
• GROUPING
• GROUPING SETS
• GROUPING_ID
• IGNORE NAV KEEP NAV
• IS PRESENT
• LAG LEAD
• MEDIAN
• Measure
• Model
• Moving Average
• NTILE
• NULLs First
• NULLs Last
• Over
• PARTITION
• PERCENTILE_DISC
• PERCENT_RANK
• PRESENTV
• RATIO_TO_REPORT
• REGR_AVGX
• REGR_AVGY
• REGR_COUNT
• REGR_INTERCEPT
• REGR_R2
• REGR_SLOPE
• REGR_SXX
• REGR_SXY
• REGR_SYY
• ROW_NUMBER
• RULES UPDATE
• Range
• Rank
• Rank Row
• Ratio Portion
• Rollup
• STATS_MODE
• STATS_WSR_TEST
• STDDEV
• STDDEV_POP
• STDDEV_SAMP
• Start With
• Sum
• Top Values
• UNBOUNDED FOLLOWING
• VARIANCE
• VAR_POP
• VAR_SAMP
• connect by
• percentile_cont