ＯＲＡＣＬＥ：ＳＱＬメモ、テーブル一覧の抽出

コメント、テーブルスペースも含めて。

-- テーブル一覧を抽出する
SELECT A.TABLE_NAME AS TABLE_NAME, A.TABLESPACE_NAME AS TABLESPACE_NAME, A.STATUS AS STATUS
  , A.TABLE_TYPE AS TABLE_TYPE,C.COMMENTS AS COMMENTS
FROM USER_TAB_COMMENTS C RIGHT OUTER JOIN 
  ((SELECT TABLE_NAME, TABLESPACE_NAME, STATUS, 'TABLE' AS TABLE_TYPE FROM USER_TABLES) 
    Union (SELECT VIEW_NAME AS TABLE_NAME, '' AS TABLESPACE_NAME, '' AS STATUS, 'VIEW' AS TABLE_TYPE FROM USER_VIEWS)) A 
  ON A.TABLE_NAME = C.TABLE_NAME
ORDER BY A.TABLE_TYPE, A.TABLE_NAME;