In Oracle, REGR_SLOPE is a linear regression analytic function which is used to measure the slope of a line. Its computation formula looks like this:
COVAR_POP(x,y) / VAR_POP(y)
It accepts two numeric inputs. Note that the pairs having any argument's value as NULL are eliminated, but the final result might be NULL as per the above computation.
In the syntax, 'x' is referred to as the dependent variable and 'y' is referred to as the independent variable of the Regression Line.
The SQL query below uses REGR_SLOPE to measure the slope of line formed by the columns DEPTNO and SAL.
SELECT deptno, sal, REGR_SLOPE(deptno, sal) OVER (partition by deptno) "REGR_SLOPE"
Related Code Snippets:
- REGR_SLOPE - REGR_SLOPE returns the slope of the line. After the elimination of null (expr1, expr2...