哪位大神可以帮我看看这个oracle语句怎么转化为sql？？谢谢！！

[Sncsdn]

declare vsdw varchar2(36) := 0;
vfrow sys_refcursor;
sqls varchar2(32767);
begin
open vfrow for 'select lsbzdw_dwbh from lsbzdw where LSBZDW_MX='1'';
loop
fetch vfrow into vsdw;
exit when vfrow%NOTFOUND;

sqls := sqls || ' select '''||vsdw||'02'' as id,'||vsdw||' as centitycode,''Detail_02'' as CASSTYPECODE , lsbzdw_dwbh as bh,lsbzdw_dwmc as mc,lsbzdw_sjgs as cparentcode from lsbzdw where LSBZDW_MX='1'
union all
select '''||vsdw||'03'' as id,'||vsdw||' as centitycode,''Detail_03'' as CASSTYPECODE , lswbzd_bzbh as bh,lswbzd_bzmc as mc from lswbzd
union all
select '''||vsdw||'05'' as id,'||vsdw||' as centitycode,''Detail_05'' as CASSTYPECODE , lsbmzd_bmbh as bh,lsbmzd_bmmc as mc from lsbmzd where lsbmzd_dwbh='''||vsdw||'''
union all
select '''||vsdw||'08'' as id,'||vsdw||' as centitycode,''Detail_08'' as CASSTYPECODE , lshsxm_xmnm as bh,lshsxm_xmmc as mc,SUBSTRING(lshsxm_xmnm,1,2) as cparentcode from lshsxm2015 where lshsxm_dwbh='''||vsdw||'''LSHSXM_LBID='0ed7914c-ed75-4e2e-bf75-d8d6d715924d'
union all
select '''||vsdw||'09'' as id,'||vsdw||' as centitycode,''Detail_09'' as CASSTYPECODE , LSWLDW_wldwbh as bh,LSWLDW_dwmc as mc from lswldw where LSWLDW_DWLB='01' and LSWLDW_WLDWBH not in (select LSBZDW_DWBH from LSBZDW)
union all
select '''||vsdw||'10'' as id,'||vsdw||' as centitycode,''Detail_10'' as CASSTYPECODE , LSWLDW_wldwbh as bh,LSWLDW_dwmc as mc from lswldw where hgLSWLDW_DWLB='02'
union all
select '''||vsdw||'11'' as id,'||vsdw||' as centitycode,''Detail_11'' as CASSTYPECODE , LSWLDW_wldwbh as bh,LSWLDW_dwmc as mc from lswldw where LSWLDW_DWLB='02'
union all
select '''||vsdw||'13'' as id,'||vsdw||' as centitycode,''Detail_13'' as CASSTYPECODE , lshsxm_xmnm as bh,lshsxm_xmmc as mc ,
Case when length(lshsxm_xmnm) == 4 then lshsxm_xmnm
when length(lshsxm_xmnm) == 6 then lshsxm_xmnm
when length(lshsxm_xmnm) > 7 then substring(lshsxm_xmnm,1,length(lshsxm_xmnm)-2) end as cparentcode from lshsxm where LSHSXM_LBID='997fb97f-f0bc-42ce-9713-3abaef5192c4' and lshsxm_dwbh='''||vsdw||'''
union all
';
end loop;
execute immediate('create or replace view VW_T_BASIC_ASSCODE
as '||sqls || 'select '''' as id,'''' as centitycode，'''' as CASSTYPECODE , '''' as bh,'''' as mc ,'''' as cparentcode from dual');
end;

[lisong770818]

为了建个视图，费了这么大的劲啊。