select a.人名,b.基本工资,c.考勤天数,d.奖金,e.税率,(b.基本工资*考勤天数/应出勤天数+奖金)*(1-税率) as 实际发送工资
into 应发工资201211191350
from 人员表 a
left join 基本工资表 b on a.userid=b.userid
left join 考勤表 c on a.userid=c.userid
left join 奖金表 d on a.userid=d.userid
left join 税金表 e on (b.基本工资*考勤天数/应出勤天数+奖金) between 税金区间

create or replace procedure XXX(flag out varchar2) is
tempnum varchar(10);
begin
  flag    := '1';
  tempnum := 0;
---取数据源
 for resoutce_cour in (select tce.id
                          from tresource tce
                         where not exists
                         (select 1
                                  from trole_resource tre
                                 where tre.resource_id = tce.id
                                   and tre.role_id = 1000)
                           and tce.name in ('xx', 'xx', 'xx')) loop
    dbms_output.put_line(resoutce_cour.id);
--拼凑数据
tempnum :=resoutce_cour.id||'abc'；
...
...
    
--插入新表
insert into trole_resource
    values
      ((select  max(id)+1 from ddd), tempnum .. );
    
  end loop;
  commit;
exception
  when others then
    flag := '0';
    rollback;
  
end XX;