w*****t
发帖数: 300 | 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********o
发帖数: 31 | 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!
|
|
