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

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=sub