Redian新闻
>
How to know which database I am connected?
avatar
How to know which database I am connected?# Database - 数据库
h*r
1
using sqlplus for oracle, is there anyway to know which
database I
am connecting to?
Another thing is how to let sqlplus to connect to the
database I
want to?
thanks a lot.
avatar
s*j
2
select * from v$database

【在 h****r 的大作中提到】
: using sqlplus for oracle, is there anyway to know which
: database I
: am connecting to?
: Another thing is how to let sqlplus to connect to the
: database I
: want to?
: thanks a lot.

avatar
h*r
3
thanks a lot, but I only can use this SQL sentence at some
database,
for some other, it will said the table or view is not exist.

【在 s****j 的大作中提到】
: select * from v$database
avatar
s*e
4
version.
or the user haas not teh right to see this view.
Do you study the Oracle by yourslef now?

【在 h****r 的大作中提到】
: thanks a lot, but I only can use this SQL sentence at some
: database,
: for some other, it will said the table or view is not exist.

avatar
s*j
5
That's privilege problem.
As I remember, you need SELECT ANY TABLE privilege to see
this view.

【在 h****r 的大作中提到】
: thanks a lot, but I only can use this SQL sentence at some
: database,
: for some other, it will said the table or view is not exist.

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