一:返回一个字符串

create or replace function Test_zhiban(ID in varchar2) return number
as
vss varchar2(200);
Result number;
begin
 vss: = 'select QX_YH_QM from BBEQ.TEMP where QX_YH_DM=' ||ID||;
 EXECute IMMEDIATE vss INTO Result;
 return Result;
end;

二:返回日期

create or replace function GetDayTime(datevalue in varchar2) return varchar2
is
--取日期
   strtime     varchar2(100);

begin

  strtime := to_char(to_date(datevalue,'yyyy-mm-dd'),'yyyy-mm-dd');

return(strtime);

end GetDayTime;