oracle 테이블 컬럼 정보 조회하기

SELECT 
       A.OWNER 
     , A.COLUMN_ID
     , A.COLUMN_NAME
     , DECODE(NULLABLE,'N','Not Null') NULLABLE
     , DATA_TYPE
      ||'('
      ||CASE WHEN DATA_TYPE IN ('NUMBRER') THEN DATA_PRECISION||','||DATA_SCALE
            WHEN DATA_TYPE IN ('DATE') THEN ''
            ELSE TO_CHAR(DATA_LENGTH)
        END
      ||')' DATA_SIZE
     , DATA_DEFAULT DATA_DEFAULT
     , B.COMMENTS COMMENTS
  FROM ALL_TAB_COLUMNS  A
     , ALL_COL_COMMENTS B
 WHERE A.TABLE_NAME  = '테이블명'
   AND A.OWNER       = 'OWER명'
   AND A.TABLE_NAME  = B.TABLE_NAME
   AND A.COLUMN_NAME = B.COLUMN_NAME
   AND A.OWNER       = B.OWNER
ORDER BY COLUMN_ID;