How to view the database name of oracle

The methods to view Oracle database names are: Direct method: use SELECT statement to query the v$database view. Indirect method: Use tools such as SQL*Plus command line client, Oracle SQL Developer, or Java API to connect to the database.

How to view Oracle database name

Direct way:

Use the SELECT statement to query v$database view:

 <code class="sql">SELECT name FROM v$database;</code>

Indirect method:

1. Using the SQL*Plus command line client:

   • Connect to the database.
   • Execute the SHOW USER command to get the current database name.

2. Using Oracle SQL Developer:

   • Open a database connection in Oracle SQL Developer.
   • In the navigation tree, expand the database node and the database name will be displayed under the node.

3. Using Java API:

   • Import oracle.jdbc.driver.OracleConnection .
   • After connecting to the database, use OracleConnection.getDatabaseName() method to get the database name.

Example:

 <code class="java">import oracle.jdbc.driver.OracleConnection; // Connect to the database Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "oracle"); // Get and print the database name OracleConnection oracleConn = (OracleConnection) conn; System.out.println("Database name: " oracleConn.getDatabaseName()); // Close the connection conn.close();</code>

The above is the detailed content of How to view the database name of oracle. For more information, please follow other related articles on the PHP Chinese website!