Oracle 将查询结果存储在表中

create or replace procedure pro_basic_emp(P_employee_number in number) is
  l_employee_number   pr_basic.employee_number%type;
  l_full_name         pr_basic.full_name%type;
  l_job               pr_basic.job%type;
  l_name              pr_basic.name%type;
  l_salary            pr_basic.salary%type;
  cursor pr_basic_emp is
    SELECT papf.employee_number  as EmployeeNumber,
           papf.full_name        as EmployeeName,
           pj.NAME               as job,
           haou.NAME             as ORGANIZATION,
           ppp.proposed_salary_n as salary
      FROM per_all_people_f          papf,
           per_all_assignments_f     paaf,
           per_jobs                  pj,
           hr_all_organization_units haou,
           per_position_definitions  ppd,
           per_all_positions         pap,
           per_pay_proposals         ppp
     WHERE 1 = 1
       AND SYSDATE BETWEEN papf.effective_start_date AND
           papf.effective_end_date
       AND papf.current_employee_flag = 'Y'
       AND papf.employee_number IS NOT NULL
       AND paaf.person_id = papf.person_id
       AND SYSDATE BETWEEN paaf.effective_start_date AND
           paaf.effective_end_date
       AND paaf.job_id = pj.job_id
       AND paaf.organization_id = haou.organization_id
       AND paaf.position_id = pap.position_id
       AND papf.employee_number = p_employee_number
       AND pap.position_definition_id = ppd.position_definition_id
       AND ppp.pay_proposal_id =
           (SELECT MAX(pay_proposal_id)
              FROM per_pay_proposals
             WHERE assignment_id = paaf.assignment_id)
     order by employee_number asc;
begin
  for hr_basic_emp in pr_basic_emp loop
     if (pr_basic is null) then

      insert into pr_basic
        (employee_number, full_name, job, name, salary)
      values
        (pr_basic.l_employee_number,pr_basic.l_full_name, pr_basic.l_job, pr_basic.l_name, pr_basic.l_salary);
    end if;
  end loop;
end pro_basic_emp;

create or replace procedure pro_basic_emp(P_employee_number in number) is
begin
      insert into pr_basic
        (employee_number, full_name, job, name, salary)
    SELECT papf.employee_number  as EmployeeNumber,
           papf.full_name        as EmployeeName,
           pj.NAME               as job,
           haou.NAME             as ORGANIZATION,
           ppp.proposed_salary_n as salary
      FROM per_all_people_f          papf,
           per_all_assignments_f     paaf,
           per_jobs                  pj,
           hr_all_organization_units haou,
           per_position_definitions  ppd,
           per_all_positions         pap,
           per_pay_proposals         ppp
     WHERE 1 = 1
       AND SYSDATE BETWEEN papf.effective_start_date AND
           papf.effective_end_date
       AND papf.current_employee_flag = 'Y'
       AND papf.employee_number IS NOT NULL
       AND paaf.person_id = papf.person_id
       AND SYSDATE BETWEEN paaf.effective_start_date AND
           paaf.effective_end_date
       AND paaf.job_id = pj.job_id
       AND paaf.organization_id = haou.organization_id
       AND paaf.position_id = pap.position_id
       AND papf.employee_number = p_employee_number
       AND pap.position_definition_id = ppd.position_definition_id
       AND ppp.pay_proposal_id =
           (SELECT MAX(pay_proposal_id)
              FROM per_pay_proposals
             WHERE assignment_id = paaf.assignment_id)
     order by employee_number asc;
end pro_basic_emp;