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
Post a Comment