Difference between revisions of "Selecting Database Name"
From TekiWiki
| Line 11: | Line 11: | ||
When used as part of a larger query, this does not need to join the v$database pseudo table. | 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]]. | + | This is particularly useful in packaged solutions like [[PeopleSoft]], SAP etc. |
For more hints and tips like this, see the eBook: | For more hints and tips like this, see the eBook: | ||
Revision as of 17:18, 27 May 2016
To select the Oracle Database name, the most common method is:
SELECT name FROM v$database
This, however, requires special permissions. 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.
For more hints and tips like this, see the eBook:
|
