oracle函数的写法

,Nk'Gy*x)jc:T'u3d0一:返回一个字符串

create or replace function Test_zhiban(ID in varchar2) return number51Testing软件测试网-|9w)~(gz!z7@D
as51Testing软件测试网k{h,vyV
v Z;iO;U
vss varchar2(200);
l7\_*k _eQ}0Result number;
\)P)Gm Kg0begin51Testing软件测试网n~1T,_[-mW0?
 vss: = 'select QX_YH_QM from BBEQ.TEMP where QX_YH_DM=' ||ID||;51Testing软件测试网pR5O/S ]Z\
 EXECute IMMEDIATE vss INTO Result;51Testing软件测试网;J*^gQ.XH9_E@
 return Result;
W:@"K]J POe0j0end;

*QgV-vp,`YmN0二:返回日期51Testing软件测试网ig7m1Pn2R#]Q

2?6M'@'z;RY@?k0create or replace function GetDayTime(datevalue in varchar2) return varchar2
'Y-gb JM'M0is
z/E+F{P+L(X oLW0--取日期
In-W#t?D0i}Sw[5i0   strtime     varchar2(100);

ZJ)ymfozI0begin

W)I{8_:H0k0  strtime := to_char(to_date(datevalue,'yyyy-mm-dd'),'yyyy-mm-dd');

tV*\sh X ? dxha0return(strtime);

end GetDayTime;
,L?wGY.yw0