반응형
밑줄긋고, 빨간색으로 표시된 표식 주목, TAB T, USER_TAB_COMMENTS TC, user_TAB_COLUMNS C, USER_COL_COMMENTS CC
SELECT
T.TNAME AS TABLE_NAME,
TC.COMMENTS AS TABLE_COMMENTS,
C.COLUMN_NAME AS COLUMN_NAME,
C.DATA_TYPE AS DATA_TYPE,
CC.COMMENTS AS COLUMN_COMMENTS
FROM TAB T, USER_TAB_COMMENTS TC, user_TAB_COLUMNS C, USER_COL_COMMENTS CC
WHERE T.TNAME = TC.TABLE_NAME
AND T.TNAME = C.TABLE_NAME
AND T.TNAME = CC.TABLE_NAME
AND C.COLUMN_NAME = CC.COLUMN_NAME
반응형
'DataBase > oracle' 카테고리의 다른 글
oracle 10g 이상 WM_CONCAT (여러 row 를 한컬럼에) (0) | 2011.08.30 |
---|---|
Oracle 가로데이터 세로정렬 (0) | 2011.08.02 |
Oracle - DB link (0) | 2011.04.14 |
oracle table space create and user creation (0) | 2011.04.12 |
Oracle User Creation And Authority[유저생성 및 권한] (0) | 2011.02.22 |