sql - Insert into table from query result error ERROR at line 1: ORA-00913: too many values -


hi can on how figure out? i'm getting error:

error @ line 1:ora-00913: many values

since columns inserted in table equal. i've searched other sites , follow instruction on how insert result of query table

insert globe_billing_report (bill_year,  bill_month, acct_no, emp_id,  assignee,  designation,  terr_num,  jdeid,  mobile_no, bill_num, bill_type,  credit_limit,  plan_id, balance,  payments, credits_prior_adj,   overdue, msf,  other_charges,  debit_adj,  credit_adj,  local_data,  ndd,  idd,  roam,  sms,  gprs,  wis_usage,  loading_charges,  vat,  oct_data,  current_charges,  total_amount_due,  dummy_cost_centre,  cerps_accnt_code, accnt_code_for_msf,  msf_plan, tag) select emp_data.year_data,    emp_data.month_data, emp_data.accnt_num, emp_data.empid_data, globe_billing.assignee, emp_data.designation, emp_data.terr_num, emp_data.jdeid, globe_billing.mobile_no, globe_billing.bill_no, globe_billing.bill_type, globe_billing.credit_limit, globe_billing.plan_id, globe_billing.balance, globe_billing.payments, globe_billing.credits_prior_adj, globe_billing.overdue, globe_billing.msf, globe_billing.other_charges, globe_billing.debit_adj, globe_billing.credit_adj, globe_billing."local", globe_billing.ndd, globe_billing.idd, globe_billing.roam, globe_billing.sms, globe_billing.gprs, globe_billing.wis_usage, globe_billing.loading_charges, globe_billing.vat, globe_billing."oct", globe_billing.current_charges, globe_billing.total_amount_due, emp_data.dummy_cost_centre, emp_data.cerps_accnt_centre, emp_data.accnt_code_for_msf, emp_data.msf_plan, emp_data.department_tag, emp_data.status emp_data inner join globe_billing on emp_data.accnt_num = globe_billing.acct_no , emp_data.month_data = globe_billing.bill_month , emp_data.year_data = globe_billing.bill_year emp_data.status '%ned%'; 

that's cause insert specifying 38 columns whereas select specifying 39 columns , looks emp_data.status in select query.


Comments