oracle查询表统计行数与注释

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

 

查询表统计行数与注释