Oracle - Table Schema 조회
2011. 7. 15. 09:49ㆍplming/DB
SELECT a.OWNER, A.TABLE_NAME, A.COLUMN_ID, A.COLUMN_NAME, B.COMMENTS, a.DATA_TYPE, DATA_LENGTH, a.NULLABLE
FROM ALL_TAB_COLUMNS A, ALL_COL_COMMENTS B
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME LIKE 'TB_JH7%'
ORDER BY A.TABLE_NAME, A.COLUMN_ID
FROM ALL_TAB_COLUMNS A, ALL_COL_COMMENTS B
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME LIKE 'TB_JH7%'
ORDER BY A.TABLE_NAME, A.COLUMN_ID
'plming > DB' 카테고리의 다른 글
| [펌] Oracle RANK() OVER (0) | 2011.11.04 |
|---|---|
| [펌] 오라클에서 not exists, not in, minus의 성능차이 (0) | 2011.11.04 |
| Oracle - Table Comment 조회 (0) | 2011.07.15 |
| Sybase - Error code별 메시지 (0) | 2010.11.23 |
| Sybase - Transact-SQL functions (0) | 2010.11.23 |