SELECT TABLE_NAME,NUM_ROWS,(select COMMENTS from user_tab_comments WHERE TABLE_NAME=C.TABLE_NAME) FROM user_tables C
WHERE NUM_ROWS>0
查询表统计行数与注释
SELECT TABLE_NAME,NUM_ROWS,(select COMMENTS from user_tab_comments WHERE TABLE_NAME=C.TABLE_NAME) FROM user_tables C
WHERE NUM_ROWS>0
查询表统计行数与注释
原文：http://www.cnblogs.com/CoreXin/p/8045035.html