avatar
w*t
1
In oracle, how to get information such as hwo many table I have, what the
names are, how many users are in the server? Is it possibel to querry these
by SQL?
Thanks!
avatar
x*o
2

absolutely. to the tables you owned, u can easily attain it by a query.
but to the server users, you need administrator's privilege.
the sql should be:
ttitle left 'OBJECTS OWNED BY 'sql.user
column object_name format a64 heading 'Object Name'
column object_type format a15 heading 'Type'
select object_type, object_name
from user_objects
order by object_type desc, object_name;
ttitle off

【在 w*****t 的大作中提到】
: In oracle, how to get information such as hwo many table I have, what the
: names are, how many users are in the server? Is it possibel to querry these
: by SQL?
: Thanks!

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。