ORACLE用自定义函数实现EXCEL中的NORMSINV与NORMSDIST函数功能

bugma

于 2021-12-08 23:09:25 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 oracle excel sql

本文链接：https://blog.csdn.net/q394979433/article/details/121803426

如下为ORACLE自定义函数：

CREATE OR REPLACE FUNCTION NORMSINV(P IN NUMBER)
  RETURN NUMBER 
AS
  A1     NUMBER(32, 22) := -39.696830286653757;
  A2     NUMBER(32, 22) := 220.9460984245205;
  A3     NUMBER(32, 22) := -275.92851044696869;
  A4     NUMBER(32, 22) := 138.357751867269;
  A5     NUMBER(32, 22) := -30.66479806614716;
  A6     NUMBER(32, 22) := 2.5066282774592392;
  B1     NUMBER(32, 22) := -54.476098798224058;
  B2     NUMBER(32, 22) := 161.58583685804089;
  B3     NUMBER(32, 22) := -155.69897985988661;
  B4     NUMBER(32, 22) := 66.80131188771972;
  B5     NUMBER(32, 22) := -13.280681552885721;
  C1     NUMBER(32, 22) := -0.0077848940024302926;
  C2     NUMBER(32, 22) := -0.32239645804113648;
  C3     NUMBER(32, 22) := -2.4007582771618381;
  C4     NUMBER(32, 22) := -2.5497325393437338;
  C5     NUMBER(32, 22) := 4.3746641414649678;
  C6     NUMBER(32, 22) := 2.9381639826987831;
  D1     NUMBER(32, 22) := 0.0077846957090414622;
  D2     NU