조건에 맞는 값으로 특정 Column 의 값을 UPDATE 하는 구문입니다.
UPDATE WOOJJA_CODE P
SET WCD = (SELECT CD
FROM CODE_MASTER
WHERE SUBCD = P.SUBCD)
WHERE EXISTS (SELECT CD
FROM CODE_MASTER
WHERE SUBCD = P.SUBCD);
행복한 고수되셔요.
woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\\\
UPDATE WOOJJA_CODE P
SET WCD = (SELECT CD
FROM CODE_MASTER
WHERE SUBCD = P.SUBCD)
WHERE EXISTS (SELECT CD
FROM CODE_MASTER
WHERE SUBCD = P.SUBCD);
행복한 고수되셔요.
woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\\\
반응형
'DATABASE > ORACLE' 카테고리의 다른 글
| [ORACLE] Windows 7 64Bit 에 Oracle Client 설치하기 (2) | 2010.09.15 |
|---|---|
| [ORACLE] Oracle Bulk Insert (0) | 2010.03.19 |
| [ORACLE] Oracle Lock 해제 관련 query (0) | 2009.06.05 |
| [ORACLE] Oracle .NET Provider - Data connection pooling (0) | 2009.04.02 |
| [ORACLE] Oracle Developer Tools for Visual Studio .NET (0) | 2009.04.02 |