by 임상진 [2005.10.05 11:38:30]
update test_tbl TB1set MGR = (select TB2.ENAME FROM TEST_TBL TB2 WHERE TB2.EMPNO = TB1.MGR
)