Windows 64-bit with JDK 8 Included This archive includes both SQL Developer and an embedded copy of the Java 8 Development Kit (JDK). Simply extract the zip to a fresh directory and run the sqldeveloper.exe in the top directory. The EXE is configured to run the embedded JDK by default. Easily build, debug, maintain, and refactor databases inside Visual Studio. SQL Server Data Tools (SSDT) introduces a declarative model that spans all the phases of database development—enabling continuous integration and deployment for your databases. Apr 29, 2021 User Review of SQL Developer: 'In our company, Oracle SQL Developer is using by Oracle developer by default in AppDev department across the global. We use Oracle SQL Developer since Oracle 11g, replaced the license product Toad for Oracle. Oracle SQL Developer able to provide all the feature required by database development activities.

Note:

This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool.

If you plan to use SQL Developer as part of the Oracle Database release 11 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:

1.1 SQL Developer System Recommendations

This section describes the recommended minimum values for CPU, memory, display, disk storage, and other resources on the supported systems.

Table 1-1 Recommendations for Windows Systems

Resource	Recommended Minimum Value
Operating System	Windows 2000-Service Pack 4 Windows XP-Service Pack 2 Windows 2003 R2
CPU Type and Speed	Pentium IV 2 GHz MHz or faster
Memory	1 GB RAM
Display	65536 colors, set to at least 1024 X 768 resolution
Hard Drive Space	42 MB if you already have JDK 1.5 110 MB if you do not have JDK 1.5
Java SDK	JDK 5.0 Update 6 or later for Windows, available at: `http://www.javasoft.com` (If you do not have this SDK installed, you can use SQL Developer, but you must download and install the kit for Windows systems with no Java SDK or with a Sun Java SDK release lower than 5.0.)

Table 1-2 Recommendations for Linux Systems

Resource	Recommended Minimum Value
Operating System	Red Hat Enterprise Linux 3.0 Fedora Core 4
CPU Type and Speed	Pentium IV 2 GHz or faster
Memory	1 GB RAM
Display	65536 colors, set to at least 1024 X 768 resolution
Hard Drive Space	110 MB
Java SDK	JDK 5.0 Update 6 or later for Linux, available at: `http://www.javasoft.com`

Table 1-3 Recommendations for Mac OS X Systems

Resource	Recommended Minimum Value
Operating System	Apple Mac OS X Version 10.4.x
CPU Type and Speed	Dual 1.25 GHz G4/G5 (1 GHz G4 minimum)
Memory	1.5 GB RAM (1 GB minimum)
Display	'Thousands' of colors
Hard Drive Space	110 MB
Java SDK	Sun J2SE 1.5 release 1, available at: `http://www.apple.com/support/downloads/java2se50release1.html`

1.2 Installing and Starting SQL Developer

This section contains subsections with instructions for installing SQL Developer on all supported systems.

SQL Developer does not require an installer. To install SQL Developer, you will need an unzip tool. You can download a free, cross-platform unzip tool, Info-Zip, available at http://www.info-zip.org/.

Important:

Do not install SQL Developer into any existing ORACLE_HOME. You will not be able to uninstall it using Oracle Universal Installer.

Important:

If you are using a pre-release (Early Adopter) version of SQL Developer, and if you want to be able to continue to use this pre-release version after installing the official release kit, you must unzip the official release kit into a different directory than the one used for the pre-release version.

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. Suggestion: Create a shortcut for the SQL Developer executable file that you install, and always use it to start SQL Developer.

For Windows systems, there are two kits: one for systems on which the Sun Java SDK release 1.5.0_06 or later is installed, and another for systems with no Java SDK or a Sun Java SDK release earlier than 1.5.0_06. Be sure to download the appropriate kit.

Before you install SQL Developer, look at the remaining sections of this guide to see if you need to know or do anything else first.

The steps for installing SQL Developer depend on whether or not you will be using it on a Windows system that does not have the Sun Java SDK release 1.5.0_06 or later installed:

For a Windows system with the Sun Java release 1.5.0_06 or later installed, follow the instructions in Section 1.2.1.
For all other systems (Linux and Mac OS X systems, and Windows systems with no Java SDK or a Sun Java SDK release earlier than 1.5.0_06 or later installed), follow the instructions in Section 1.2.2.

Sql Developer Tool Tutorial

1.2.1 Windows Systems with JDK5.0

To install and start SQL Developer on a Windows system on which the Sun Java J2SE JDK 5.0 (Update 6 or later) is installed, follow these steps:

Unzip the SQL Developer kit into a folder (directory) of your choice (for example, C:Program Files). This folder will be referred to as <sqldeveloper_install>.
Unzipping the SQL Developer kit causes a folder named sqldeveloper to be created under the <sqldeveloper_install> folder (for example, C:Program Filessqldeveloper). It also causes many files and folders to be placed in and under that directory.
To start SQL Developer, go to <sqldeveloper_install>sqldeveloper, and double-click sqldeveloper.exe.

If you are asked to enter the full pathname for java.exe, click Browse and find java.exe. For ex