| Database Name! [message #59383] |
Fri, 14 November 2003 10:04  |
Marmik
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
Hi Everyone
It might be a primitive question. How can I retrive the name of the database on which I am working ?
Waiting for reply.
thanks
|
|
|
|
| Re: Database Name! [message #59384 is a reply to message #59383] |
Fri, 14 November 2003 13:08  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
These queries will give the database name (I'm sure there
are other methods as well):
SELECT sys_context('USERENV','DB_NAME')
FROM dual;
SELECT name
FROM v$database;
SELECT value
FROM v$parameter
WHERE name = 'db_name';
Best regards.
Frank Naude
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
