SELECT INSERT 예제

INSERT INTO TABLE_NAME SELECT * FROM TMP_TABLE

ex) INSERT INTO APPROVALCODE SELECT 'TEST', APPROVAL_CODE, APPROVAL_TYPE, APPROVAL_FLAG, APPROVAL_DESC FROM APPROVALCODE WHERE APPROVAL_TYPE = 'A';