CREATE function f_id(@parentid int)
returns @re table(id int,level int,sid varchar(1000),m_name1 varchar(7000))
as
begin
declare @l int
set @l=0
insert @re select m_id,@l,right(10000+m_id,4),m_name
from menu where father=@parentid
while @@rowcount>0
begin
set @l=@l+1
insert @re select a.m_id,@l,b.sid+','+right(10000+a.m_id,4),b.m_name1+'/'+a.m_name
from menu a,@re b
where a.father=b.id and b.level=@l-1
end
return
end谁帮我把上面的函数改成ORACLE里面的函数
returns @re table(id int,level int,sid varchar(1000),m_name1 varchar(7000))
as
begin
declare @l int
set @l=0
insert @re select m_id,@l,right(10000+m_id,4),m_name
from menu where father=@parentid
while @@rowcount>0
begin
set @l=@l+1
insert @re select a.m_id,@l,b.sid+','+right(10000+a.m_id,4),b.m_name1+'/'+a.m_name
from menu a,@re b
where a.father=b.id and b.level=@l-1
end
return
end谁帮我把上面的函数改成ORACLE里面的函数
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货