+ -
当前位置:首页 → 问答吧 → 未找到关键字from

未找到关键字from

时间:2011-12-02

来源:互联网

create or replace procedure insert_tb_conut
(
 p_empID in tb_employee.empid%type
)
is

v_empid tb_salary.empid%type;
v_salary tb_salary.salary%type;
v_bonus tb_salary.bonus%type;
v_deduct tb_salary.bonus%type;
v_ewdate date;
v_ewconut tb_extrawork.ewconut%type;
v_taxrate number;
v_holiday number:=4;
v_deptAllowance tb_department%type;
v_ewsalary number;
begin
  --获取数据
  --获取部门津贴
  SELECT deptAllowance into v_deptAllowance from tb_department where deptID=(SELECT deptID from tb_employee where empid=p_empID);
  --获取各种字段数据
  SELECT t1.empid into v_empid,t1.Salary INTO v_salary, t1.bonus INTO v_bonus, t1.deduct INTO v_deduct, nvl(t2.ewdate,null) INTO v_ewdate, nvl(t2.ewconut,null) INTO v_ewconut FROM tb_salary t1 left join tb_Extrawork t2 ON t1.empid = t2.EmpID where t1.empid=insert_tb_conut.p_empID);
  SELECT salary INTO v_sal from tb_salary;
   
   
  v_ewsalary:=v_ewconut*(v_salary/monthDay);
   
   
  --获取税率
  if v_salary>4500 then
  v_taxrate:=0.2;
  else
  v_taxrate:=0.03;
  end if;
   
  --插入数据
  insert INTO tb_conut(cuntid,empid,bonus,deduct,ewdate,ewconut,taxrate,holiday,deptallowance,ewsalary) values(sep_employee_empid.nextval,v_empid,v_bonus,v_deduct,v_ewdate,v_ewconut,v_taxrate,v_holiday,v_deptAllowance,v_ewsalary);
end;

PL/SQL:ORA-00923:未找到要求的FROM关键字
PL/SQL:SQL Statement ignored

作者: rankx   发布时间: 2011-12-02

我都看了一天了!眼都大了

作者: rankx   发布时间: 2011-12-02