How to get Db Name?

[lincs]

Hi All,

Can somebody tell me how I can obtain the name of the Oracle Db (using a query or from PL-SQL)?

I don't want to use system tables directly as the client does not have access, also I know I can "select * from global_name", but I would like only the Db Name without the domain name added.

Thanks a lot!

Lincoln.

 

[Guest_imported]

Hi,
just take a substring from global_name:
select substr(global_name,1,instr(global_name,'.')-1)
from global_name;
regards