SELECT TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME, ORDINAL_POSITION 결과물 : toad에서 쿼리 실행 후 grid를 excel로 복붙한 형태 출처 : http://blog.naver.com/srader/140196181727