Tuesday, 5 August 2014

Current Database Name in Oracle

In oracle, we can find out the database name to which we have currently connected:-


  1. If you have a admin privileges:-

SELECT NAME FROM V$DATABASE;


     2. If you don't have admin privileges:-

SELECT ORA_DATABASE_NAME FROM DUAL;


Read Also:-  Find out current user name

No comments:

Post a Comment