SOFTMOA TECHNOLOGY
[ oracle ] merge
소프트모아가 정리한 기술 기록입니다.
Contents
작성일 2015. 10. 15.
MERGE /*+ USE_HASH(B A) */
INTO TB_CTNS_030 B
USING (
SELECT
A.LECT_SEQ AS BB
,A.CBT_LECT_ID
\tFROM\t
\t\tTB_CTNS_020 A
) A
ON(
A.CBT_LECT_ID = B.CBT_LECT_ID
)
WHEN MATCHED THEN
UPDATE SET
B.LECT_SEQ = A.LECT_SEQ
Share this
Database
Showing 1 to 10 of 87 entries
