Oracle - Table Comment 조회

2011. 7. 15. 09:48plming/DB

SELECT A.TABLE_NAME, B.COMMENTS
FROM   ALL_TABLES A, ALL_TAB_COMMENTS B
WHERE  A.TABLE_NAME = B.TABLE_NAME
  AND  A.TABLE_NAME LIKE 'TB_JH7%'
ORDER BY A.TABLE_NAME