UPDATE TABLE1 T1 SET (NAME, DESC) = ( SELECT T2.NAME, T2.DESC FROM TABLE2 T2 WHERE T1.ID = T2.ID )WHERE EXISTS ( SELECT 1 FROM TABLE2 T2 WHERE T1.ID = T2.ID );

1. 테이블 목록조회SELECT *FROM all_all_tables; SELECT *FROM dba_tables; SELECT *FROM ALL_OBJECTSWHERE OBJECT_TYPE = 'TABLE' -- 접속한 계정의 테이블 목록보기SELECT *FROM tabs; SELECT *FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'; SELECT *FROM USER_TABLES; -- 테이블 코멘트 보기SELECT *FROM ALL_TAB_COMMENTSWHERE TABLE_NAME = '테이블명' SELECT *FROM USER_TAB_COMMENTS; 2. 컬럼 목록조회SELECT *FROM COLS;WHERE TABLE_NAME = '테이블명'; SELECT ..