dummy question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

dummy question

dummy question# Database - 数据库

w*t2099-12-08 08:12

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!

x*o2099-12-08 08:12

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!