[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