오라클 테이블 스키마 보기

SELECT  B.COLUMN_NAME  AS 컬럼명
        , B.DATA_TYPE AS 테이터타입,
        B.DATA_LENGTH     AS 길이,
        B.NULLABLE AS NULL구분,
        B.COLUMN_ID AS 컬럼순서,
        A.COMMENTS AS 설명
FROM    USER_COL_COMMENTS A, USER_TAB_COLUMNS B
WHERE  B.TABLE_NAME = A.TABLE_NAME
    AND B.COLUMN_NAME = A.COLUMN_NAME
    AND B.TABLE_NAME LIKE '테이블명'
ORDER BY B.COLUMN_ID;