1.1 SQL Developer System Recommendations. This section describes the recommended minimum. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients installed on my machine and my ORACLEHOME variable points to 64-bit client. I am not able to start pl/sql developer even i specify the 32-bit client in Tools-Preferences of pl-sql developer. While SQLServer or MySQL has a download package, in which after you install it, a visual tool is available, after installing Oracle, you need to install another additional visual tool, but it has a variety of choices for you.Based on my working experience, I think that PL/SQL Developer is the best tool.However, we still look at some other choices. If Oracle Database (Release 11 or later) is also installed, a version of SQL Developer is also included and is accessible through the menu system under Oracle.This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database. Connect to an Oracle database. After you install the matching Oracle client driver, you can connect to an Oracle database. To make the connection, take the following steps: From the Home tab, select Get Data. From the Get Data window that appears, select More (if necessary), select Database Oracle database, and then select Connect.
Note:
This guide assumes that you plan to download SQL Developer and run it as a freestanding tool.
For information about operating system versions supported for Oracle JDK 8, see http://www.oracle.com/technetwork/java/javase/certconfig-2095354.html.
If you plan to use SQL Developer as part of an Oracle Database release installation, see the Oracle Database installation documentation.
Please read the information in this chapter before you install Oracle SQL Developer. This chapter contains the following major sections:
