만들어가는 세상

[ORACLE] 유용한 쿼리들2 UPDATE JOIN UPDATE TEST_TABLE A SET A.DESCRIPTION = (SELECT B.DESCRIPTION FROM TEMP_LOG B WHERE A.NO = B.NO ), A.WEB_DESCRIPTION = (SELECT B.WEB_DESCRIPTION FROM TEMP_LOG B WHERE A.NO = B.NO ) WHERE EXISTS (SELECT * FROM TEMP_LOG B WHERE A.NO = B.NO);TABLE ALL DROP SELECT 'DROP TABLE ' || object_name || ';' FROM user_objects WHERE object_type ='TABLE';TA..