오라클 테이블뷰정보 가져오기(table description을 출력하기 위한 sql작성)

SELECT 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 = 'TB_NB_SV_BH_RWDBRDSTB'     <--정보가져올 테이블명
AND A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME= B.COLUMN_NAME
AND A.OWNER = B.OWNER