Tag Archives: oracle

Find database names in Oracle

Below select queries help us to find database names in Oracle, and also we can find the  SID, service name and server host. Oracle query command to  find the database name is: select * from global_name; select ora_database_name from dual; Oracle query command to check the SID (or instance name): select sys_context(‘userenv’,’instance_name’) from dual; Oracle query… Read More »

Oracle JDBC Thin Driver Formats

In this post we will know about the common Oracle JDBC Thin Driver Formats which are used in JDBC connection in java. Oracle JDBC Thin driver using a Service Name:  jdbc:oracle:thin:@//<host>:<port>/<ServiceName> Example: jdbc:oracle:thin:@//121.0.0.1:1522/XE   Oracle JDBC Thin driver  using an SID:  jdbc:oracle:thin:@<host>:<port>:<SID> Example: jdbc:oracle:thin:121.0.0.1:1522:X01A Note: SID support is not in use. Oracle suggest to use service… Read More »