How to figure out Oracle Connection String from PL SQL Developer's connection?

16,053

I was able to figure it out myself. Under Help -> Support in PL SQL Developer, there is a tab called TNS Names that lists all the available ORACLE SIDs that are used in the application.

Share:
16,053
Karthik Balasubramanian
Author by

Karthik Balasubramanian

Updated on June 04, 2022

Comments

  • Karthik Balasubramanian
    Karthik Balasubramanian almost 2 years

    I PL/SQL Developer installed (pre-loaded by my company) on my laptop, when I want to connect to an ORACLE database, all I give it is Database Name, User Name and Password and it connects successfully.

    I also have DBVisualizer installed on my machine (I downloaded it because it like its ease of use) which when connecting to ORACLE wants to know SID or TNSNAMES or ORACLE Service name, none of which I know.

    How can i figure those details out from my working PL SQL Development so that I can use my DBVisualizer to connect to the same ORACLE database

    Thanks Kay