1SELECT ATC.OWNER, 2 ATC.TABLE_NAME, 3 UTC.COMMENTS, 4 ATC.COLUMN_NAME, 5 ATC.DATA_TYPE, 6 ATC.DATA_LENGTH, 7 ATC.NULLABLE, 8 UCC.COMMENTS 9 FROM (SELECT ATC.OWNER, 10 ATC.TABLE_NAME, 11 ATC.COLUMN_NAME, 12 ATC.DATA_TYPE, 13 ATC.DATA_LENGTH, 14 ATC.NULLABLE 15 FROM ALL_TAB_COLUMNS ATC 16 WHERE ATC.OWNER IN ('GTJA21')) ATC 17 LEFT OUTER JOIN USER_COL_COMMENTS UCC 18 ON ATC.TABLE_NAME = UCC.TABLE_NAME 19 AND ATC.COLUMN_NAME = UCC.COLUMN_NAME 20 LEFT OUTER JOIN USER_TAB_COMMENTS UTC 21 ON ATC.TABLE_NAME = UTC.TABLE_NAME 22 ORDER BY ATC.TABLE_NAME, 23 ATC.COLUMN_NAME
--多个用户下的表明細+表注釋+字段明細+字段注釋
1 SELECT ATC.OWNER, 2 ATC.TABLE_NAME, 3 ATC.COLUMN_NAME, 4 UTC.COMMENTS, 5 ATC.DATA_TYPE, 6 ATC.DATA_LENGTH, 7 ATC.NULLABLE, 8 UCC.COMMENTS 9 FROM (SELECT ATC.OWNER, 10 ATC.TABLE_NAME, 11 ATC.COLUMN_NAME, 12 ATC.DATA_TYPE, 13 ATC.DATA_LENGTH, 14 ATC.NULLABLE 15 FROM ALL_TAB_COLUMNS ATC 16 WHERE ATC.OWNER IN ('UserName1', 'UserName2')) ATC 17 LEFT OUTER JOIN ALL_COL_COMMENTS UCC 18 ON ATC.TABLE_NAME = UCC.TABLE_NAME 19 AND ATC.COLUMN_NAME = UCC.COLUMN_NAME 20 LEFT OUTER JOIN ALL_TAB_COMMENTS UTC 21 ON ATC.TABLE_NAME = UTC.TABLE_NAME 22 ORDER BY ATC.TABLE_NAME, ATC.COLUMN_NAME