Oracle不太懂,麻烦帮忙把下面的函数改成pl/sql语言create function fn_xs9(
@id varchar(20)
)
returns varchar(300)
as
begin
declare @r varchar(300),@i int
set @r=''
set @i=1
select @r=@r+'('+rtrim(@i)+')'+xs_report,@i=@i+1 from t_xs_report where xm_id=@idreturn @r
end
@id varchar(20)
)
returns varchar(300)
as
begin
declare @r varchar(300),@i int
set @r=''
set @i=1
select @r=@r+'('+rtrim(@i)+')'+xs_report,@i=@i+1 from t_xs_report where xm_id=@idreturn @r
end
return varchar2
is
r varchar2(300);
i int;
begin
r:=''
i:=1
select r||'('||rtrim(i)||')'||xs_report,i+1 into r,i from t_xs_report where xm_id=id;
return r;
end