oracle函数的写法

H3X ~{3E'TM.D0一:返回一个字符串51Testing软件测试网}Tq+y*~ [i3U

cyx7F*]!n LMc0create or replace function Test_zhiban(ID in varchar2) return number51Testing软件测试网m1q[N)Z%dvFB
as
N@|mk&Z8^NC`0vss varchar2(200);
U7g0e`o j0Result number;51Testing软件测试网,n*k-fiT c
`N'O]y
begin51Testing软件测试网O5}
C)Ej!GN%m7_&i9?s
 vss: = 'select QX_YH_QM from BBEQ.TEMP where QX_YH_DM=' ||ID||;51Testing软件测试网-g,L6}9SDJ&~y
 EXECute IMMEDIATE vss INTO Result;51Testing软件测试网3vTJ;eO5t
 return Result;
I6e8oilP"f0end;

Z(eVOLCR i0二:返回日期

?7M,aH@|6os+S%k m0create or replace function GetDayTime(datevalue in varchar2) return varchar251Testing软件测试网+Jfu
dO
is51Testing软件测试网7q:l3A qO/`2H~[
--取日期51Testing软件测试网fU6eW8rj
   strtime     varchar2(100);

9G;m*kV7l3zy|0begin

I]
D1R.Vz0  strtime := to_char(to_date(datevalue,'yyyy-mm-dd'),'yyyy-mm-dd');51Testing软件测试网c,s.YJ!Q4v _V

return(strtime);51Testing软件测试网*@c4AU1]9r,P2|;x

end GetDayTime;
*Ea%i0k-V0