Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Get name of current Oracle database connection (Read 3334 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Get name of current Oracle database connection
30.11.06 at 11:34:19
 
Get name of current Oracle database connection
 
Sometimes there may be the need to determine in SQL to which database a connection was made. In Oracle databases  you can run the following query to determine the database name:
 
SQL> select global_name from global_name;
 
GLOBAL_NAME
---------------------------------------------
TESTDATABASE.MYCOMPANY.COM
 
SQL>
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1