REGR_SYY « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. REGR_SYY
1.REGR_SYY(y, x) Returns REG_COUNT(y, x) * VAR_POP(y)
2.REGR_AVGY(y, x) Returns the average of y after eliminating x and y pairs where either x or y is null
3.REGR_SYY(expr1, expr2): For sum of squares