v_lmmc varchar2(20).--栏目名称 v_sql varchar2(1000). --定义取工资栏目的游标 cursor cur_lmmc is 0select distinct lmmc FROM tmp_gztjlsb. begin --定义动态SQL v_sql:=@#0select rydm,xm@#. --遍历工资栏目并拼写成插入的SQL for cur_lmmc_rec in cur_lmmc loop v_lmmc:=cur_lmmc_rec.lmmc. v_sql:=v_sql||@#,@#||@#sum(decode(lmmc@#||@#,@#@#@#||v_lmmc||@#@#@#,je))@#||@# @#||v_lmmc. end loop. v_sql:=v_sql||@# from tmp_gztjlsb group by rydm,xm@#. execute immediate @#insert into @#||p_table||@# @#||v_sql. commit. end prc_rs_gzndbb.