提示该语句执行出错,
update T_Fa_FaCurCard set
(fcreatorid,fcreatetime,flastupdateuserid,flastupdatetime,fcontrolunitid,fnumber,fbizdate,fhandlerid,fdescription,fhaseffected,fauditorid,fsourcebillid,fsourcefunction,fcompanyid,fassetcatid,fassetname,fassetamt,fmeasureunitid,faccountdate,foriginmethodid,fusestatusid,feconomicpurpid,fstorecityid,fspecs,fparea,fmfr,flevfrdate,fpaperno,fdeptid,fkeeperid,forigintype,foriginunit,fremark,fcurrencyid,fexrate,foriginamt,fassetvalue,fbuyvalue,fbuyaccudepr,faddons,fdeliverdate,fstartusedate,fdeprtermcount,fusetermcount,fuseyears,faccudepr,faccudeprtyear,fneatremvalue,fdecvalue,fmeasureunitwlid,fneatvalue,fneatamt,fdeprmethodid,faccudeprchg,faccudepraccuchg,faccudepraccuclean,fdeprtterm,faccudeprchgtyear,faccudepraccuchgtyear,faccudepraccucleantyear,faccudeprall,fdecvaluechg,fdecvalueaccuchg,faccountassetid,faccountaccudeprid,faccountdecvalueid,foriginflag,fhasdisabled,fbizstatus,fcheckedstatus,fdeletedstatus,feffectedstatus,fblockedstatus,fevalleftperiod,finitevalvalue,flastevalvalue,forigindif,foriginaccudif,fhaschanged,fhascleared,fhasevaled,fhasnew,fhassplited,fisneedredepr,fperiodid,flastbillid,fleftyear,faccudeprforcal,fleftyearup,fdeprcount,flastperiodcount,fwelldeprvalue,ftempdeprmethod,ftempdeprtermcount,ftempusetermcount,fisinitchange,fisevaledbefore,fmonthdeprerate,fisoveraged,ffairvalue,ftreatmentincome,fneatleftrate,faddonfare,fworkloadfordap,fdecvaluefordap,ffiaccountdate,fleasestatus,fevalreinaccountdate,fevaldeprperiodnum,fevaldeprmodeid,fevalmonthrate,fevaladddepr,fevalremvalue,fevalyeardepr,fevaldecvalue,fevalneatvalue,fevalneatamt,foldnumber,fevalassetvalue,fevaltaxleftperiod,fevalmeasureunitwl,fevalusetermcount,fevaldeprtterm,fevalneatleftrate,flastperiodchange,flaterperioddata,fgroupnumberstatus,fgroupnumber,fvouchernumber,finputtax,fwrtyperiod,fwrtynumber,fleftyeartwo,fbarcode,fbarcodestatus,fisrequisitioned,fisborrowing,fabstract) = (
Select
mon.fcreatorid as fcreatorid,mon.fcreatetime as fcreatetime,mon.flastupdateuserid as flastupdateuserid,mon.flastupdatetime as flastupdatetime,mon.fcontrolunitid as fcontrolunitid,mon.fnumber as fnumber,mon.fbizdate as fbizdate,mon.fhandlerid as fhandlerid,mon.fdescription as fdescription,mon.fhaseffected as fhaseffected,mon.fauditorid as fauditorid,mon.fsourcebillid as fsourcebillid,mon.fsourcefunction as fsourcefunction,mon.fcompanyid as fcompanyid,mon.fassetcatid as fassetcatid,mon.fassetname as fassetname,mon.fassetamt as fassetamt,mon.fmeasureunitid as fmeasureunitid,mon.faccountdate as faccountdate,mon.foriginmethodid as foriginmethodid,mon.fusestatusid as fusestatusid,mon.feconomicpurpid as feconomicpurpid,mon.fstorecityid as fstorecityid,mon.fspecs as fspecs,mon.fparea as fparea,mon.fmfr as fmfr,mon.flevfrdate as flevfrdate,mon.fpaperno as fpaperno,mon.fdeptid as fdeptid,mon.fkeeperid as fkeeperid,mon.forigintype as forigintype,mon.foriginunit as foriginunit,mon.fremark as fremark,mon.fcurrencyid as fcurrencyid,mon.fexrate as fexrate,mon.foriginamt as foriginamt,mon.fassetvalue as fassetvalue,mon.fbuyvalue as fbuyvalue,mon.fbuyaccudepr as fbuyaccudepr,mon.faddons as faddons,mon.fdeliverdate as fdeliverdate,mon.fstartusedate as fstartusedate,mon.fdeprtermcount as fdeprtermcount,mon.fusetermcount as fusetermcount,mon.fuseyears as fuseyears,mon.faccudepr as faccudepr,mon.faccudeprtyear as faccudeprtyear,mon.fneatremvalue as fneatremvalue,mon.fdecvalue as fdecvalue,mon.fmeasureunitwlid as fmeasureunitwlid,mon.fneatvalue as fneatvalue,mon.fneatamt as fneatamt,mon.fdeprmethodid as fdeprmethodid,mon.faccudeprchg as faccudeprchg,mon.faccudepraccuchg as faccudepraccuchg,mon.faccudepraccuclean as faccudepraccuclean,mon.fdeprtterm as fdeprtterm,mon.faccudeprchgtyear as faccudeprchgtyear,mon.faccudepraccuchgtyear as faccudepraccuchgtyear,mon.faccudepraccucleantyear as faccudepraccucleantyear,mon.faccudeprall as faccudeprall,mon.fdecvaluechg as fdecvaluechg,mon.fdecvalueaccuchg as fdecvalueaccuchg,mon.faccountassetid as faccountassetid,mon.faccountaccudeprid as faccountaccudeprid,mon.faccountdecvalueid as faccountdecvalueid,mon.foriginflag as foriginflag,mon.fhasdisabled as fhasdisabled,mon.fbizstatus as fbizstatus,mon.fcheckedstatus as fcheckedstatus,mon.fdeletedstatus as fdeletedstatus,mon.feffectedstatus as feffectedstatus,mon.fblockedstatus as fblockedstatus,mon.fevalleftperiod as fevalleftperiod,mon.finitevalvalue as finitevalvalue,mon.flastevalvalue as flastevalvalue,mon.forigindif as forigindif,mon.foriginaccudif as foriginaccudif,mon.fhaschanged as fhaschanged,mon.fhascleared as fhascleared,mon.fhasevaled as fhasevaled,mon.fhasnew as fhasnew,mon.fhassplited as fhassplited,mon.fisneedredepr as fisneedredepr,mon.fperiodid as fperiodid,mon.flastbillid as flastbillid,mon.fleftyear as fleftyear,mon.faccudeprforcal as faccudeprforcal,mon.fleftyearup as fleftyearup,mon.fdeprcount as fdeprcount,mon.flastperiodcount as flastperiodcount,mon.fwelldeprvalue as fwelldeprvalue,mon.ftempdeprmethod as ftempdeprmethod,mon.ftempdeprtermcount as ftempdeprtermcount,mon.ftempusetermcount as ftempusetermcount,mon.fisinitchange as fisinitchange,mon.fisevaledbefore as fisevaledbefore,mon.fmonthdeprerate as fmonthdeprerate,mon.fisoveraged as fisoveraged,mon.ffairvalue as ffairvalue,mon.ftreatmentincome as ftreatmentincome,mon.fneatleftrate as fneatleftrate,mon.faddonfare as faddonfare,mon.fworkloadfordap as fworkloadfordap,mon.fdecvaluefordap as fdecvaluefordap,mon.ffiaccountdate as ffiaccountdate,mon.fleasestatus as fleasestatus,mon.fevalreinaccountdate as fevalreinaccountdate,mon.fevaldeprperiodnum as fevaldeprperiodnum,mon.fevaldeprmodeid as fevaldeprmodeid,mon.fevalmonthrate as fevalmonthrate,mon.fevaladddepr as fevaladddepr,mon.fevalremvalue as fevalremvalue,mon.fevalyeardepr as fevalyeardepr,mon.fevaldecvalue as fevaldecvalue,mon.fevalneatvalue as fevalneatvalue,mon.fevalneatamt as fevalneatamt,mon.foldnumber as foldnumber,mon.fevalassetvalue as fevalassetvalue,mon.fevaltaxleftperiod as fevaltaxleftperiod,mon.fevalmeasureunitwl as fevalmeasureunitwl,mon.fevalusetermcount as fevalusetermcount,mon.fevaldeprtterm as fevaldeprtterm,mon.fevalneatleftrate as fevalneatleftrate,mon.flastperiodchange as flastperiodchange,mon.flaterperioddata as flaterperioddata,mon.fgroupnumberstatus as fgroupnumberstatus,mon.fgroupnumber as fgroupnumber,mon.fvouchernumber as fvouchernumber,mon.finputtax as finputtax,mon.fwrtyperiod as fwrtyperiod,mon.fwrtynumber as fwrtynumber,mon.fleftyeartwo as fleftyeartwo,mon.fbarcode as fbarcode,mon.fbarcodestatus as fbarcodestatus,mon.fisrequisitioned as fisrequisitioned,mon.fisborrowing as fisborrowing,mon.fabstract as fabstract
From T_Fa_FaMonCard mon Where
mon.FFaPeriodID = 'XgR8IeYoTXekPmkHEN+dE4I4jEw='
And mon.FCompanyID = 'qf0kDTR1SAmothL3ecRQdcznrtQ='
) where T_Fa_FaCurCard.FCompanyID = 'qf0kDTR1SAmothL3ecRQdcznrtQ='
Oracle错误代码:ORA-01427: single-row subquery returns more than one row
正常会引起该问题的原因是哪些呢,我该从哪几个方向入手?
推荐阅读