Re: Database name

You can use global_name view which is public: select substr(global_name,1,instr(global_name,'.')-1) from global_name;

Or as sys you can:

1. grant select on v$database to public;
2. create a view such as: create view dbname as select name from v$database; create public synonym dbname for dbname; grant select on dbname to public; then select name from dbname;
3. create a function that returns the dbname: create function dbname return varchar2 is dbname v$database.name%type; begin select name into dbname from v$database; return dbname; end; / create public synonym dbname for dbname; grant execute on dbname to public; and use it in queries or PL/SQL: select dbname from dual; set serveroutput on size 10000 begin dbms_output.put_line(dbname); end; /

--
Have a nice day
Michel


Mike Streeton <mikes_at_crazydiamondcorp.demon.co.uk> a écrit dans le message :
963915284.18793.0.nnrp-14.c2ded5f0_at_news.demon.co.uk...


> Is there a public view that gives the database name, I could use V$DATABASE

> but you need to be a DBA to get it. Are there any others?

>

> Many Thanks

>

> Mike

>

>