h****r
发帖数: 2056 | 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. | s****j
发帖数: 14 | 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.
| h****r
发帖数: 2056 | 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
| s********e
发帖数: 62 | 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.
| s****j
发帖数: 14 | 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.
|
|
