Oracle | DBMS_STAT_FUNCS

Oracle DBMS_STAT_FUNCS_AUX Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented

AUTHID CURRENT_USER

Data Types COEFF_ARR

Dependencies

DBMS_STAT_FUNCS

DBMS_STAT_FUNCS_AUX_LIB

PLITBLM

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtstts.plb

Subprograms

CALC_SW_A1	CDF_BINOMIAL	CDF_WEIBULL
CALC_SW_A2	CDF_EXPONENTIAL	MINX
CALC_SW_COEF	CDF_NORMAL	POLY
CALC_SW_FAC	CDF_POISSON	SIGN
CALC_SW_SUMM2	CDF_UNIFORM

CALC_SW_A1

Undocumented dbms_stat_funcs_aux.calc_sw_a1( n IN NUMBER, fac IN NUMBER) RETURN NUMBER;

TBD

CALC_SW_A2

Undocumented dbms_stat_funcs_aux.calc_sw_a2( n IN NUMBER, summ2 IN NUMBER, fac IN NUMBER) RETURN NUMBER;

TBD

CALC_SW_COEF

Undocumented dbms_stat_funcs_aux.calc_sw_coef( i IN NUMBER, n IN NUMBER, a1 IN NUMBER, a2 IN NUMBER, fac IN NUMBER) RETURN NUMBER;

TBD

CALC_SW_FAC

Undocumented dbms_stat_funcs_aux.calc_sw_fac(n IN NUMBER) RETURN NUMBER;

SELECT dbms_stat_funcs_aux.calc_sw_fac(42);

      

      DBMS_STAT_FUNCS_AUX.CALC_SW_FAC(42)

      -----------------------------------

                               6.44197151

CALC_SW_SUMM2

Undocumented dbms_stat_funcs_aux.calc_sw_summ2(n IN NUMBER) RETURN NUMBER;

SELECT dbms_stat_funcs_aux.calc_sw_summ2(42);

      

      DBMS_STAT_FUNCS_AUX.CALC_SW_SUMM2(42)

      -------------------------------------

                                 19.6424283

CDF_BINOMIAL

Undocumented dbms_stat_funcs_aux.cdf_binomial( x IN NUMBER, n IN NUMBER, p IN NUMBER) RETURN NUMBER;

TBD

CDF_EXPONENTIAL

Undocumented dbms_stat_funcs_aux.cdf_expontential( x IN NUMBER, lambda IN NUMBER, mu IN NUMBER) RETURN NUMBER;

TBD

CDF_NORMAL

Undocumented dbms_stat_funcs_aux.cdf_normal( x IN NUMBER, mu IN NUMBER, stdev IN NUMBER) RETURN NUMBER;

TBD

CDF_POISSON

Undocumented dbms_stat_funcs_aux.cdf_poisson( x IN NUMBER, lambda IN NUMBER) RETURN NUMBER;

TBD

CDF_UNIFORM

Undocumented dbms_stat_funcs_aux.cdf_uniform( x IN NUMBER, locationparam IN NUMBER, scaleparam IN NUMBER) RETURN NUMBER;

TBD

CDF_WEIBULL

Undocumented dbms_stat_funcs_aux.cdf_weibull( x IN NUMBER, alpha IN NUMBER, mu IN NUMBER, beta IN NUMBER) RETURN NUMBER;

TBD

MINX

Undocumented dbms_stat_funcs_aux.minx( n1 IN NUMBER, n2 IN NUMBER) RETURN NUMBER;

SELECT dbms_stat_funcs_aux.minx(1,2);

      

      DBMS_STAT_FUNCS_AUX.MINX(1,2)

      -----------------------------

                                  1

      

      SELECT dbms_stat_funcs_aux.minx(-1,2);

      

      DBMS_STAT_FUNCS_AUX.MINX(-1,2)

      ------------------------------

                                  -1

      

      SELECT dbms_stat_funcs_aux.minx(3,2);

      

      DBMS_STAT_FUNCS_AUX.MINX(3,2)

      -----------------------------

                                  2

      

      SELECT dbms_stat_funcs_aux.minx(3,242);

      

      DBMS_STAT_FUNCS_AUX.MINX(3,242)

      -------------------------------

                                    3

POLY

Undocumented dbms_stat_funcs_aux.poly( c IN sys.dbms_stat_funcs_aux.coeff_arr, n IN NUMBER, x IN NUMBER) RETURN NUMBER;

TBD

SIGN

Undocumented dbms_stat_funcs_aux.sign( a IN NUMBER, b IN NUMBER) RETURN NUMBER;

SELECT dbms_stat_funcs_aux.sign(1,1);

      

      DBMS_STAT_FUNCS_AUX.SIGN(1,1)

      -----------------------------

                                  1

      

      SELECT dbms_stat_funcs_aux.sign(0,1);

      

      DBMS_STAT_FUNCS_AUX.SIGN(0,1)

      -----------------------------

                                  0

      

      SELECT dbms_stat_funcs_aux.sign(1,0);

      

      DBMS_STAT_FUNCS_AUX.SIGN(1,0)

      -----------------------------

                                  1

      

      SELECT dbms_stat_funcs_aux.sign(2,104);

      

      DBMS_STAT_FUNCS_AUX.SIGN(2,104)

      -------------------------------

                                    2

      

      SELECT dbms_stat_funcs_aux.sign(-2,104);

      

      DBMS_STAT_FUNCS_AUX.SIGN(-2,104)

      --------------------------------

                                     2

      

      SELECT dbms_stat_funcs_aux.sign(-2,-104);

      

      DBMS_STAT_FUNCS_AUX.SIGN(-2,-104)

      ---------------------------------

                                     -2