Does anybody know of a API that I can use to capture the name of the database that I am connected to? Here is the scenario, I login to my application, now on the first page I want to display the name of the database I am connected to. Let say this is the entry from my tns file:
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xx.xxx)(PORT = 1521))
(SID = DATABASENAME)
I want to display DATABASENAME in UI after I log in.