SELECT OWNER,COUNT(*) FROM ALL_TABLES GROUP BY OWNER;
SELECT * FROM ALL_TABLES WHERE OWNER = '用户名'
SELECT COUNT(*) FROM TABS
SELECT COUNT(*) FROM USER_TABLES;
oracle 查询数据库表的数量
最新推荐文章于 2022-09-27 13:54:26 发布
SELECT OWNER,COUNT(*) FROM ALL_TABLES GROUP BY OWNER;
SELECT * FROM ALL_TABLES WHERE OWNER = '用户名'
SELECT COUNT(*) FROM TABS
SELECT COUNT(*) FROM USER_TABLES;