Oracle和mysql批量查询用户下所有表名和表名注释

Oracle下查询：

SELECT table_name 表名,table_comment 表说明 FROM information_schema.TABLES WHERE
table_schema = '用户名'
ORDER BY table_name desc

MySQL下查询：

select table_name,comments from user_tab_comments order by table_name desc