These are multiple ways to find out the database name in Oracle. The complexsql is the database name on which user is been connected. User can find out the database name using dual table. If you can Print the V_database_name it will give you the database name. :V_no:=dbms_utility.get_parameter_value(‘db_name’,:V_no,:V_database_name ) To do this user need to create one PLSQL procedure. The third type to get database name is using the dbms utility.The oracle system function get_parameter_value from dbms_utility package will give you the database name. The database name is Complexsql to which user is connected. The following query is used to find out Oracle Database name using Global_name. The Global_name table is publicly accessible to any database user logged in to the database. The global_name table contains the default value of database name and database domain together. The second method for finding out database name is using global_name system table. Step 1 : Describe V$database view to see the columns If you don’t have access to the view kindly run following query : Mainly the user with DBA privileges will access this view. User needs to have the permission to access V$database view. I would like to mention prerequisite to use this query. Kindly use following steps to find the database name using V$Database view. There are so many columns in V$Database view. If you are using Oracle SQL developer or Toad to connect with your oracle database you need to use the select query to find out the name of the connected database. The view named V$database is used to find out the database details from the oracle. There are so many types of system views in Oracle. The first method to find out oracle database name is using system views. Type 1 : Finding Oracle Database name using System View named V$Database I would like to explain multiple ways for finding out the database name for which you are connected. These steps are really very important in day to day database activities. The main purpose of this article is to find out your oracle database name with easy steps. In my previous articles I have clearly given you idea about different systems tables in oracle with its use.In this article I would like to give you information about Oracle Database Name and Finding the Database Name in detail.