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
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.