在iSQL plus中选择数据库名称
问题描述:
我有一个数据库,但我不知道它的名称,我想知道如何使用iSQL Plus知道它. 因此,如果有人可以提出建议.
I have a database but I don't know it's name, and I'm wondering how I can know it using iSQL Plus. So if anyone could please advise.
答
连接到RDBMS后,可以发出以下命令来查询数据库名称:
Once connected to your RDBMS, you can issue the following command to query the database name:
select ora_database_name from dual;
在我的系统上:
On my system:
SQL> select ora_database_name from dual;
ORA_DATABASE_NAME
--------------------------------------------------------------------------------
XE