Re: Accessing the Databse name with pl/sql

"Dave S." <mastercara_at_wanadoo.fr> writes:

> Hi, I need to extract y database name using pl/sql commands... how
> can I do? thahks in advance

I like:

  select global_name from global_name;

Because you don't need to have access to the dictionary. Disadvantage as other posted here 'global name' is changeable through 'alter database global_name rename to ...';

Harald Received on Fri Aug 15 2003 - 08:28:09 CDT