Oracle常用SQL语句

1 查询数据库下所有用户

select count(*) from dba_users;
select * from dba_users;

注意：需要有dba权限

select * from all_users;
select count(*) from all_users;

2 查询数据库中表的数量

2.1 查询当前用户下表的数量

select count(1) from user_tables;
select count(*) from user_tables;

select * from user_tables;
select * from tabs;

持续更新中