请教一下这段sql server 语句 装换成oracle 该怎么写

[monrei]

select @tables as tablesname into #425103tablename
while 1=1
begin
select @i=charindex(',',tablesname) from #425103tablename;
if @i=0 begin
select @subTableName=tablesname from #425103tablename;
select @SQLString='insert into #425103SaleCost select a.* from vender b,'
+ ltrim(rtrim(@subTableName))
+ ' a where a.venderid=b.venderid and sdate between '%D1%'
and '%D2%' %Venderid% ';
execute (@SQLString);
break;
end
else begin
select @subTableName=substring(tablesname,1,charindex(',',tablesname)-1) from #425103tablename;
select @SQLString='insert into #425103SaleCost select a.* from vender b, '
+ ltrim(rtrim(@subTableName))
+ ' a where a.venderid=b.venderid and sdate between '%D1%'
and '%D2%' %Venderid% %KL% %zL%';
execute (@SQLString);
update #425103tablename
set tablesname=substring(tablesname,charindex(',',tablesname)+1,len(tablesname))
where 1=1;
end;
end;

[monrei]

在线等

[monrei]

百分号 和 变量 忽略

[dawugui]

不懂,帮顶.

[monrei]

还是谢哈楼上的

[monrei]

再等！！