Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

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

Please provide your feedback in the comments section above. Please don't forget to follow.