[ORACLE] UPDATE문+SELECT문

1. SELECT문의 한개컬럼

 

UPDATE FROM A
SET A.colum_cd = (SELECT colum_cd FROM B WHERE colum_nm=' ')

 

2. SELECT문의 두개이상 컬럼

 

UPDATE FROM A

SET (LEC_SDATE, LEC_EDATE) =

(SELECT MIN(y.STRART_DT), MAX(y.END_DT)

FROM tableA  x, tableB y

WHERE x.YEAR = y.YEAR )