728x90
SELECT A.TABLE_NAME,
C.COMMENTS,
A.COLUMN_NAME,
B.DATA_TYPE,
B.DATA_LENGTH,
A.COMMENTS
FROM USER_COL_COMMENTS A, USER_TAB_COLS B, USER_TAB_COMMENTS C
WHERE A.TABLE_NAME = B.TABLE_NAME
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.TABLE_NAME = C.TABLE_NAME
AND A.TABLE_NAME LIKE 'TA_%';
728x90