[ORACLE] 테이블 컬럼 데이터타입 확인
SELECT a.TABLE_NAME, c.COMMENTS, a.COLUMN_NAME, b.COMMENTS, a.DATA_TYPE, a.DATA_LENGTH, a.NULLABLE FROM USER_TAB_COLUMNS a, USER_COL_COMMENTS b, USER_TAB_COMMENTS c, USER_TABLES d where 1=1 and a.TABLE_NAME = D.TABLE_NAME and a.TABLE_NAME=b.TABLE_NAME and b.TABLE_NAME=c.TABLE_NAME and a.COLUMN_NAME=b.COLUMN_NAME and a.TABLE_NAME ='BOARD' //여기에 테이블명 order by a.TABLE_NAME, a.COLUMN_ID
더보기
