Configuring Oracle SQL Developer in Windows 64 bit OS
Oracle Sql Developer is a powerful tool for accessing Oracle databases.
The developers who are familiar with Sql Server Management Studio will certaily like this tool.
The steps given below is for developers having difficulty in using SQL Developer on Windows 64 bit OS.
Ensure that, you have latest version of JDK installed in your system.
You can get the JDK from the location given below,
While downloading JDK, select the operating system as Windows 64 bit
Download SQL Developer (for Windows 64 bit) from the following location,
Extract the zip file. Locate the sqldeveloper.exe and double click it.
It will ask you to locate the java.exe file.
Now, browse to the location where the JDK is installed and locate the java.exe file.
Usually, it will be like,
Set the TNS names correctly in the tnsnames.ora file. The file is usually located in a location as shown below,
Now, launch the SQL Developer.exe.
Provide the database details you wish to connect to.