TNS-Name and Globalname

I thought to retrieve the full TNS Name (for the connect string) using

select * from global_name

would be correct. But this fit not in every cases.

How can I read the connection string (database part) from the session?

Thanks
Nicolas Received on Thu Aug 01 2002 - 16:32:58 CDT