oracle merge into用法(R1)
merge /*+parallel(16)*/
into j1_ldm.LDMT02_YE_FPXX A
USING HX_DEL.FP_NSRFPJC_DEL B
ON (
a.nsrzhdah = 'G3'||b.DJXH
and a.ywxh = 'G3'||b.NSRJCUUID
and B.deal_date >= '2014-02-10 00:00:00.000000000'
and B.deal_date <= '2014-02-28 00:54:55.000000000')
WHEN MATCHED THEN
UPDATE
SET A.sjscrq = to_char(trunc(to_timestamp(B.deal_date, 'yyyy-mm-dd hh24:mi:ss.ff')),'yyyymmdd'),
a.sjbgbz = 'D';
into j1_ldm.LDMT02_YE_FPXX A
USING HX_DEL.FP_NSRFPJC_DEL B
ON (
a.nsrzhdah = 'G3'||b.DJXH
and a.ywxh = 'G3'||b.NSRJCUUID
and B.deal_date >= '2014-02-10 00:00:00.000000000'
and B.deal_date <= '2014-02-28 00:54:55.000000000')
WHEN MATCHED THEN
UPDATE
SET A.sjscrq = to_char(trunc(to_timestamp(B.deal_date, 'yyyy-mm-dd hh24:mi:ss.ff')),'yyyymmdd'),
a.sjbgbz = 'D';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26613085/viewspace-1097118/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLServer MERGE 用法SQLServer
- merge into 用法深思
- merge into基本用法
- SQL中Merge的用法SQL
- lightdb -- merge into insert 相容 OracleOracle
- Oracle merge 與 PG新特性 UPSERTOracle
- Java 8 中 Map 騷操作之 merge() 的用法Java
- ORACLE SEQUENCE用法Oracle
- Oracle批次生成Merge指令碼程式Oracle指令碼
- Oracle實驗8--Merge與歸檔Oracle
- oracle comment on的用法Oracle
- Oracle Database 12cR2/R1中的更改OracleDatabase
- oracle中substr() instr() 用法Oracle
- 【TUNE_ORACLE】Oracle Hint之概念與用法Oracle
- ORACLE sql merge into update where條件位置與效能消耗OracleSQL
- MySQL 06 mysql 如何實現類似 oracle 的 merge intoMySqlOracle
- Sqlserver、oracle中Merge的使用方法,一個merge語句搞定多個Insert,Update,Delete操作SQLServerOracledelete
- 【Oracle的NVL函式用法】Oracle函式
- oracle樹中prior的用法Oracle
- oracle中的CURRVAL和NEXTVAL用法Oracle
- Oracle批量插入資料insert all into用法Oracle
- 【SQL】Oracle查詢轉換之 OR用法SQLOracle
- sql merge intoSQL
- Merge Or Rebase
- git mergeGit
- Oracle中Nextval用法SEQUENCE與SYS_GUID()OracleGUI
- Oracle行列轉換及pivot子句的用法Oracle
- [轉載] Oracle:start with...connect by子句的用法Oracle
- Oracle臨時表的用法總結FLOracle
- ou have not concluded your merge (MERGE_HEAD exists)
- git merge origin master git merge origin/master區別GitAST
- Oracle minus用法詳解及應用例項Oracle
- 非空校驗在oracle和mysql中的用法OracleMySql
- oracle中listagg()和wmsys.wm_concat()基本用法Oracle
- Polyphase Merge Sort
- git 中止mergeGit
- CuOI R1 - Split The Crystals
- Oracle優化案例-view merge與coe_load_sql_profile固定執行計劃(十五)Oracle優化ViewSQL
- pandas merge報錯