Chinaunix
标题:
proc编程,insert语句中select子句order by编译失败
[打印本页]
作者:
feng_yu00
时间:
2012-12-10 10:17
标题:
proc编程,insert语句中select子句order by编译失败
oracle10g
proc执行语句
EXEC SQL INSERT INTO THAgcReqConfirm
(C_ADJUSTMENTFLAG
,C_AGENCYNO
,C_BONUSTYPE
,C_BUSINESSFINISHFLAG
,C_CAUSE
,C_CSERIALNO
,C_CUSTTYPE
,C_DEDUCTBALANCEFLAG
,C_DEPOSITACCO
,C_DETAILFLAG
,C_EXCEEDFLAG
,C_FORIGINALNO
,C_FREEZECAUSE
,C_FROZENTYPE
,C_FUNDACCO
,C_FUNDCODE
,C_MEMO
,C_MONEYTYPE
,C_NETNO
,C_ORIGINALNO
,C_OTHERACCO
,C_OTHERAGENCY
,C_OTHERCODE
,C_OTHERNETNO
,C_OTHERSHARE
,C_OTHERTRADEACCO
,C_OUTBUSINFLAG
,C_RATIONKIND
,C_RATIONNO
,C_RFLAGINADVANCE
,C_REDEMPTIONREASON
,C_REGIONCODE
,C_REQUESTNO
,C_SHARETYPE
,C_TAFLAG
,C_TARGETREGIONCODE
,C_TARGETTACODE
,C_TRADEACCO
,C_TRANSFLAG
,D_DATE
,D_CDATE
,D_DOWNLOADDATE
,C_FREEZEENDDATE
,D_FUTUREBUYDATE
,D_ORIGINALCFMDATE
,D_ORIGINALSAPPDATE
,D_ORIGINALSUBSDATE
,D_RATIONDATE
,D_RDATEINADVANCE
,D_REQUESTDATE
,D_REQUESTTIME
,F_AGENCYFARE
,F_AGIO
,F_BACKFARE
,F_BALANCE
,F_CONFIRMBALANCE
,F_CONFIRMSHARES
,F_DEDUCTBALANCE
,F_DIVIDENDRATIO
,F_INTEREST
,F_INTERESTSHARES
,F_MINFARE
,F_NETVALUE
,F_ORIAGIO
,F_OTHERCONFIRMSHARES
,F_OTHERFARE
,F_PRICE
,F_RATIO
,F_RECUPERATEFEE
,F_SHARES
,F_STAMPTAX
,F_TAFARE
,F_TARGETNETVALUE
,F_TARGETPRICE
,F_TAX
,F_TOTALFARE
,F_TRADEFARE
,L_RDAYSINADVANCE
,L_RATIONTERM
,L_VALIDPERIOD
,L_SERIALNO
,C_STATUS
,F_MIDDLECONFIRMSHARES
,C_AGCFUNDCODE
,C_AGCSHARETYPE
,C_AGCNETNO
,C_AGCOTHERCODE
,C_AGCOTHERSHARE
,C_AGCOTHERNETNO
,F_CASH)
(SELECT C_ADJUSTMENTFLAG
,C_AGENCYNO
,C_BONUSTYPE
,C_BUSINESSFINISHFLAG
,C_CAUSE
,C_CSERIALNO
,C_CUSTTYPE
,C_DEDUCTBALANCEFLAG
,C_DEPOSITACCO
,C_DETAILFLAG
,C_EXCEEDFLAG
,C_FORIGINALNO
,C_FREEZECAUSE
,C_FROZENTYPE
,C_FUNDACCO
,C_FUNDCODE
,C_MEMO
,C_MONEYTYPE
,C_NETNO
,C_ORIGINALNO
,C_OTHERACCO
,C_OTHERAGENCY
,C_OTHERCODE
,C_OTHERNETNO
,C_OTHERSHARE
,C_OTHERTRADEACCO
,C_OUTBUSINFLAG
,C_RATIONKIND
,C_RATIONNO
,C_RFLAGINADVANCE
,C_REDEMPTIONREASON
,C_REGIONCODE
,C_REQUESTNO
,C_SHARETYPE
,C_TAFLAG
,C_TARGETREGIONCODE
,C_TARGETTACODE
,C_TRADEACCO
,C_TRANSFLAG
,D_DATE
,D_CDATE
,D_DOWNLOADDATE
,C_FREEZEENDDATE
,D_FUTUREBUYDATE
,D_ORIGINALCFMDATE
,D_ORIGINALSAPPDATE
,D_ORIGINALSUBSDATE
,D_RATIONDATE
,D_RDATEINADVANCE
,D_REQUESTDATE
,D_REQUESTTIME
,F_AGENCYFARE
,F_AGIO
,F_BACKFARE
,F_BALANCE
,F_CONFIRMBALANCE
,F_CONFIRMSHARES
,F_DEDUCTBALANCE
,F_DIVIDENDRATIO
,F_INTEREST
,F_INTERESTSHARES
,F_MINFARE
,F_NETVALUE
,F_ORIAGIO
,F_OTHERCONFIRMSHARES
,F_OTHERFARE
,F_PRICE
,F_RATIO
,F_RECUPERATEFEE
,F_SHARES
,F_STAMPTAX
,F_TAFARE
,F_TARGETNETVALUE
,F_TARGETPRICE
,F_TAX
,F_TOTALFARE
,F_TRADEFARE
,L_RDAYSINADVANCE
,L_RATIONTERM
,L_VALIDPERIOD
,L_SERIALNO
,C_STATUS
,F_MIDDLECONFIRMSHARES
,C_AGCFUNDCODE
,C_AGCSHARETYPE
,C_AGCNETNO
,C_AGCOTHERCODE
,C_AGCOTHERSHARE
,C_AGCOTHERNETNO
,F_CASH
FROM TAgcReqConfirm
ORDER BY C_AGENCYNO);
编译失败,提示
未命名.jpg
(24.87 KB, 下载次数: 17)
下载附件
2012-12-10 10:16 上传
proc编译,insert 中select 子句难道不能用order by吗?
作者:
doni
时间:
2012-12-10 12:32
proc中SQL的语法问题,解决的第一步就是,把SQL在sqlplus里运行一下
另: insert时,select子句是不能用order by的,
欢迎光临 Chinaunix (http://bbs.chinaunix.net/)
Powered by Discuz! X3.2