SQL Query to get SID from Oracle Database
Sometimes you need SID in JDBC URL to connect to an Oracle database.
If you already have Service Name and other connection detail, you can connect to the database and query instance_name which is SID using the following query :
select INSTANCE_NAME from V$INSTANCE
If you already have Service Name and other connection detail, you can connect to the database and query instance_name which is SID using the following query :
select INSTANCE_NAME from V$INSTANCE
posted by Nishidhdha @ 9:47 AM
0 comments
