17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE UNIQUE INDEX idx_aa_temp_gj_u1 ON AA_Temp_gj(ID);
MERGE INTO AA_Temp_gj t1
USING dual
ON (t1.ID = 101)
WHEN MATCHED THEN
UPDATE
SET dcreatesystime = to_date('2020-06-23 16:36:11', 'yyyy-mm-dd hh24:mi:ss')
,cOperator = '0222'
,cCheckMan = '0222'
,iAmount_f = 200000.0000
,dverifydate = to_date('2020-06-23 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
,iAmount = 200000.0000
,cDeptCode = '01'
,cPerson = '0102'
,cCusVen = '230007'
,cSSCode = '7'
,cBankAccount = '0406000200035158'
,dVouchDate = to_date('2020-06-23 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
,cDigest = '测试数据'
,cDepCode = 'null'
,cPersonCode = 2010731
,iAmt = 200000.0000
,iAmt_f = 200000.0000
,cBank = 'null'
,cNatBankAccount = '12345678901234567'
,cOrderID = 'null'
,cNoteNo = 'null'
,cVouchID = '0000109'
WHERE id = 101
WHEN NOT MATCHED THEN
INSERT
(ID
,dcreatesystime
,cOperator
,cCheckMan
,iAmount_f
,dverifydate
,iAmount
,cDeptCode
,cPerson
,cCusVen
,cSSCode
,cBankAccount
,dVouchDate
,cDigest
,cDepCode
,cPersonCode
,iAmt
,iAmt_f
,cBank
,cNatBankAccount
,cOrderID
,cNoteNo
,cVouchID)
VALUES
(101
,to_date('2020-06-23 16:36:11', 'yyyy-mm-dd hh24:mi:ss')
,'0222'
,'0222'
,200000.0000
,to_date('2020-06-23 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
,200000.0000
,'01'
,'0102'
,'230007'
,'7'
,'0406000200035158'
,to_date('2020-06-23 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
,'测试数据'
,NULL
,2010731
,200000.0000
,200000.0000
,'null'
,'12345678901234567'
,NULL
,NULL
,'0000109');