Oracle DBMS_STAT_FUNCS_AUX
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID CURRENT_USER
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
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)
FROM dual;

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)
FROM dual;

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)
FROM dual; 2

DBMS_STAT_FUNCS_AUX.MINX(1,2)
-----------------------------
                            1

SELECT dbms_stat_funcs_aux.minx(-1,2)
FROM dual;

DBMS_STAT_FUNCS_AUX.MINX(-1,2)
------------------------------
                            -1


SELECT dbms_stat_funcs_aux.minx(3,2)
FROM dual;

DBMS_STAT_FUNCS_AUX.MINX(3,2)
-----------------------------
                            2


SELECT dbms_stat_funcs_aux.minx(3,242)
FROM dual;

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)
FROM dual;

DBMS_STAT_FUNCS_AUX.SIGN(1,1)
-----------------------------
                            1


SELECT dbms_stat_funcs_aux.sign(0,1)
FROM dual;

DBMS_STAT_FUNCS_AUX.SIGN(0,1)
-----------------------------
                            0


SELECT dbms_stat_funcs_aux.sign(1,0)
FROM dual;

DBMS_STAT_FUNCS_AUX.SIGN(1,0)
-----------------------------
                            1


SELECT dbms_stat_funcs_aux.sign(2,104)
FROM dual;

DBMS_STAT_FUNCS_AUX.SIGN(2,104)
-------------------------------
                              2


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

DBMS_STAT_FUNCS_AUX.SIGN(-2,104)
--------------------------------
                               2


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

DBMS_STAT_FUNCS_AUX.SIGN(-2,-104)
---------------------------------
                               -2

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_STAT_FUNCS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx