最近项目搞规则引擎,然后涉及到数据库的日期比较,而业务链比较长,再加上动态表的日期数据存的都是字符串,还有的业务表日期存的就是date类型数据,这样一来无法选用to_char 或者 是to_date ,所以写了个重载函数,直接返回的数据类型为date
我写了个oracle函数重载的demo 拿出来分享下,如下
客户程序
我写了个oracle函数重载的demo 拿出来分享下,如下
CREATE OR REPLACE PACKAGE MyOverloadFunc AS
--@author:lidongbo
FUNCTION MyFunc(p_param IN NUMBER)
RETURN VARCHAR2;
PRAGMA RESTRICT_REFERENCES(MyFunc, WNDS, RNDS, WNPS, RNPS);
FUNCTION MyFunc(p_param IN DATE)
RETURN VARCHAR2;
PRAGMA RESTRICT_REFERENCES(MyFunc, WNDS, RNDS, WNPS, RNPS);
FUNCTION MyFunc(p_param IN VARCHAR2)
RETURN VARCHAR2;
PRAGMA RESTRICT_REFERENCES(MyFunc, WNDS, RNDS, WNPS, RNPS);
FUNCTION MyFunc(p_param OUT VARCHAR2)
RETURN VARCHAR2;
PRAGMA RESTRICT_REFERENCES(MyFunc, WNDS, RNDS, WNPS, RNPS);
FUNCTION MyFunc(p_paramA in VARCHAR2,p_ParamB in NUMBER)
RETURN VARCHAR2;
PRAGMA RESTRICT_REFERENCES(MyFunc, WNDS, RNDS, WNPS, RNPS);
END MyOverloadFunc ;
CREATE OR REPLACE PACKAGE BODY MyOverloadFunc AS
--@author:lidongbo
FUNCTION MyFunc(p_param IN NUMBER)
RETURN VARCHAR2 IS
BEGIN
RETURN 'NUMBER';
END MyFunc;
FUNCTION MyFunc(p_param IN DATE)
RETURN VARCHAR2 IS
BEGIN
RETURN 'DATE';
END MyFunc;
FUNCTION MyFunc(p_param IN VARCHAR2)
RETURN VARCHAR2 IS
BEGIN
RETURN 'IN VARCHAR2';
END MyFunc;
FUNCTION MyFunc(p_param OUT VARCHAR2)
RETURN VARCHAR2 IS
BEGIN
RETURN 'OUT VARCHAR2';
END MyFunc;
FUNCTION MyFunc(p_paramA in VARCHAR2,p_paramB in NUMBER)
RETURN VARCHAR2 IS
BEGIN
RETURN 'VARCHAR2 , NUMBER ';
END MyFunc;
END MyOverloadFunc;
客户程序
SELECT MyOverloadFunc.MyFunc(999) FROM Dual;
--结果:NUMBER
SELECT MyOverloadFunc.MyFunc(SYSDATE) FROM Dual;
--结果:DATE
SELECT MyOverloadFunc.MyFunc('string') FROM Dual;
--异常,原因不支持同个数同类型参数而IN OUT 不同重载
SELECT MyOverloadFunc.MyFunc('string',999) FROM Dual;
--结果:VARCHAR2 , NUMBER