SELECT
t.table_name,
a.comments,
t.num_rows
FROM
user_tables t
LEFT JOIN user_tab_comments a ON a.table_name = t.TABLE_NAME
ORDER BY
t.NUM_ROWS DESC;
Oracle 查看当前用户下所有表的数据条数
于 2023-03-16 17:47:09 首次发布
SELECT
t.table_name,
a.comments,
t.num_rows
FROM
user_tables t
LEFT JOIN user_tab_comments a ON a.table_name = t.TABLE_NAME
ORDER BY
t.NUM_ROWS DESC;