Oracle查询表位置和列注释等

-- 注释
SELECT t.TABLE_NAME, t.COMMENTS, c.COLUMN_NAME, c.COMMENTS
FROM USER_COL_COMMENTS c
         JOIN USER_TAB_COMMENTS t ON c.TABLE_NAME = t.TABLE_NAME
WHERE 1 = 1
--   AND t.TABLE_NAME = ''
--   AND t.COMMENTS like '%%'
--   AND c.COLUMN_NAME = ''
--   AND c.COMMENTS like '%%'
;

-- 数据量
SELECT NUM_ROWS
FROM USER_TABLES
WHERE TABLE_NAME = '';