oracle script : java 实体互相付值自动匹配 ，自动生成代码

select
 case when rowno = 1 then remark1
 when  rowno = 2 then java_code 
 when rowno = 3 then null end as  java_code1
 from (
 select  
        rowno,
        '//' || remark  as remark1,
        ' detailData.set' ||  detail_data_item || '(ifSwkDat.get' || value_col  ||  '());' java_code
        , remark
 from (
            select  
                     substr(col_temp,0,col_with) detail_data_item
                     ,a value_col
                     ,b remark
            from (
                    select 
                          replace (trim(t1.a),'swkDtl.set','detailData.set'),
                          replace (trim(t1.a),'swkDtl.set','') col_temp,
                          instr(replace (trim(t1.a),'swkDtl.set',''),'(')-1 col_with,
                          t2.a,
                          t2.b
                    from huangcnt1 t1 full join huangcnt2 t2 on t1.a like '%' || trim(t2.a) || '%'
                    where t1.a is not null
                    order by t2.a 
                    )
            ) a
          , (
          select 
                 rownum rowno 
          from dual 
                 connect by level <=3) b
          order by value_col,rowno
          )

 

自付值

 

select
 case when rowno = 1 then remark
 when  rowno = 2 then java_code 
 when rowno = 3 then null end as  java_code1
 from (
select '//' || b remark,
   'this.ifSwkDat.set' || trim(a) || '(this.' ||  lower(substr(trim(a),0,1)) || substr(trim(a),2,800)  || ');'  java_code,
    rowno
from huangcnt1
          ,(
          select 
                 rownum rowno 
          from dual 
                 connect by level <=3) b
order by java_code,rowno
)