Difference between revisions of "Selecting Database Name"
From TekiWiki
| Line 1: | Line 1: | ||
To select the [[Oracle Database]] name, the most common method is: | To select the [[Oracle Database]] name, the most common method is: | ||
| + | |||
<pre> | <pre> | ||
SELECT name FROM v$database | SELECT name FROM v$database | ||
</pre> | </pre> | ||
| − | This, however, requires special permissions to be able to read the pseudo table v$ | + | This, however, requires special permissions to be able to read the pseudo table v$database. |
| − | + | ||
The database name is part of the session context and can be selected using the following function: | The database name is part of the session context and can be selected using the following function: | ||
| + | |||
<pre> | <pre> | ||
SELECT sys_context('USERENV', 'DB_NAME') FROM dual | SELECT sys_context('USERENV', 'DB_NAME') FROM dual | ||
Revision as of 22:40, 18 December 2016
To select the Oracle Database name, the most common method is:
SELECT name FROM v$database
This, however, requires special permissions to be able to read the pseudo table v$database.
The database name is part of the session context and can be selected using the following function:
SELECT sys_context('USERENV', 'DB_NAME') FROM dual
When used as part of a larger query, this does not need to join the v$database pseudo table.
This is particularly useful in packaged solutions like PeopleSoft, SAP etc. where permissions to see v$database are non-standard.
For more hints and tips like this, see the eBook:
|
