How to Download SQL Developer
SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and cloud deployments. It offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your third-party databases to Oracle.
download sql developer
In this article, you will learn how to download SQL Developer for different platforms, how to start it, and how to update it. You will also find some useful features and benefits of using SQL Developer, as well as some frequently asked questions.
What is SQL Developer?
SQL Developer is a graphical user interface (GUI) tool that allows you to interact with Oracle Database using SQL and PL/SQL code. You can browse database objects, run SQL statements, edit and debug PL/SQL statements, and run reports, whether provided or created. You can also perform various database administration tasks, such as creating users, roles, tablespaces, indexes, constraints, triggers, views, sequences, synonyms, etc. You can also import and export data, compare schemas and data, tune queries, monitor performance, and more.
SQL Developer supports Oracle Database versions 11gR2, 19c, 21c, and higher. It also supports Oracle Database in the Oracle Cloud and on-premises. It runs on any operating system that supports Java, such as Windows, Mac OS X, Linux, etc. It has three interfaces: desktop, browser, and command line.
Why Use SQL Developer?
SQL Developer is a powerful tool that can help you save time and maximize the return on investment in the Oracle Database technology stack. Here are some of the benefits of using SQL Developer:
It is free and fully supported by Oracle. You do not need to pay any license fee or subscription fee to use it.
It is easy to use and learn. You do not need any special training or certification to use it. It has a user-friendly interface that guides you through the various features and functions.
It is versatile and flexible. You can use it for different purposes and scenarios, such as development, testing, debugging, administration, migration, modeling, reporting, etc. You can also customize it according to your preferences and needs.
It is integrated and compatible. You can use it with other Oracle products and tools, such as Oracle Database Cloud Service, Oracle Application Express (APEX), Oracle REST Data Services (ORDS), Oracle Data Modeler (SDDM), Oracle SQLcl (command line), etc. You can also use it with third-party databases, such as MySQL, SQL Server, Sybase ASE, DB2, or Teradata.
How to Download SQL Developer for Different Platforms
You can download SQL Developer from the Oracle Technology Network (OTN) website. There are different downloads available for different platforms. Depending on your platform and preference, you may need to download and install the Java Development Kit (JDK) separately or not. The following sections will show you how to download SQL Developer for Windows, Mac OS X and ARM64, Linux RPM, and other platforms Windows
If you are using Windows, you can download SQL Developer for Windows with JDK 8 included or SQL Developer for Windows without JDK. The former is a zip file that contains both SQL Developer and JDK 8, while the latter is a zip file that contains only SQL Developer and requires you to have JDK 8 installed separately on your machine. The file size of the former is larger than the latter, but it saves you the hassle of installing JDK 8 separately.
To download SQL Developer for Windows with JDK 8 included, follow these steps:
Go to the on the OTN website.
Scroll down to the section "Windows 64-bit with JDK 8 included".
Click on the "Accept License Agreement" radio button.
Click on the link "sqldeveloper-21.2.1.204.1703-x64.zip" to download the zip file.
Save the zip file to your preferred location on your machine.
Extract the zip file to a folder of your choice.
Open the folder and double-click on the file "sqldeveloper.exe" to launch SQL Developer.
To download SQL Developer for Windows without JDK, follow these steps:
Go to the on the OTN website.
Select the "JDK Download" button under "Java SE 8u301".
Scroll down to the section "Java SE Development Kit 8u301".
Select the "Accept License Agreement" radio button.
Select the link "jdk-8u301-windows-x64.exe" to download the executable file.
Save the executable file to your preferred location on your machine.
Run the executable file and follow the instructions to install JDK 8 on your machine.
Go to the on the OTN website.
Scroll down to the section "Windows 64-bit/32-bit".
Select the "Accept License Agreement" radio button.
Select the link "sqldeveloper-21.2.1.204.1703-no-jre.zip" to download the zip file.
Save the zip file to your preferred location on your machine.
Extract the zip file to a folder of your choice.
Open the folder and double-click on the file "sqldeveloper.exe" to launch SQL Developer.
Mac OS X and ARM64
If you are using Mac OS X or ARM64, you can download SQL Developer for Mac OS X and ARM64 with JDK 11 included. This is a dmg file that contains both SQL Developer and JDK 11. You do not need to install JDK 11 separately on your machine.
download oracle sql developer for windows 10
download sql server developer edition 2022
download sql developer data modeler
download sql developer for mac
download sql developer command line
download sql developer with jdk 11
download sql server developer edition 2019
download sql developer for linux
download sql developer web
download sql developer for oracle 11g
download sql server developer edition 2017
download sql developer for oracle 19c
download sql developer for windows 7
download sql server developer edition 2016
download sql developer for oracle 12c
download sql server developer edition 2014
download sql developer for oracle 21c
download sql server developer edition free
download sql developer for mysql
download sql server developer edition iso
download sql developer for postgresql
download sql server developer edition offline installer
download sql developer for oracle cloud
download sql server developer edition docker image
download sql developer for sqlite
download sql server developer edition vs express
download sql developer for db2
download sql server developer edition license agreement
download sql developer for oracle autonomous database
download sql server developer edition system requirements
download sql developer for oracle xe
download sql server developer edition product key
download sql developer for redshift
download sql server developer edition installation guide
download sql developer for teradata
download sql server developer edition features comparison
download sql developer for mariadb
download sql server developer edition azure data studio
download sql developer for mongodb
download sql server developer edition vs community edition
To download SQL Developer for Mac OS X and ARM64 with JDK 11 included, follow these steps:
Go to the on the OTN website.
Scroll down to the section "Mac OS X and ARM64".
Select the "Accept License Agreement" radio button.
Select the link "sqldeveloper-21.2.1.204.1703-macosx-with-jdk11.dmg" to download the dmg file.
Save the dmg file to your preferred location on your machine.
Double-click on the dmg file to mount it as a drive.
Drag and drop the SQL Developer icon into your Applications folder or any other folder of your choice.
Eject the dmg file from your drive.
Open your Applications folder or any other folder where you copied SQL Developer and double-click on the SQL Developer icon to launch it.
Linux RPM
If you are using Linux RPM, you can download SQL Developer for Linux RPM with JDK required. This is a rpm file that contains only SQL Developer and requires you to have JDK 11 installed separately on your machine. You can use any JDK 11 distribution, such as Oracle JDK, OpenJDK, AdoptOpenJDK, etc.
To download SQL Developer for Linux RPM with JDK required, follow these steps:
Install JDK 11 on your machine using your preferred method or distribution. For example, you can use , Other Platforms
If you are using other platforms, such as Linux TAR, Solaris, or Windows 32-bit, you can download SQL Developer for other platforms with JDK required. This is a zip file that contains only SQL Developer and requires you to have JDK 11 installed separately on your machine. You can use any JDK 11 distribution, such as Oracle JDK, OpenJDK, AdoptOpenJDK, etc.
To download SQL Developer for other platforms with JDK required, follow these steps:
Install JDK 11 on your machine using your preferred method or distribution.
Go to the on the OTN website.
Scroll down to the section "Other Platforms".
Select the "Accept License Agreement" radio button.
Select the link "sqldeveloper-21.2.1.204.1703-no-jre.zip" to download the zip file.
Save the zip file to your preferred location on your machine.
Extract the zip file to a folder of your choice.
Open the folder and double-click on the file "sqldeveloper.sh" (for Linux TAR or Solaris) or "sqldeveloper.exe" (for Windows 32-bit) to launch SQL Developer.
How to Start SQL Developer
Once you have downloaded and installed SQL Developer, you can start it by double-clicking on the executable file or script file, depending on your platform. For example, on Windows, you can double-click on "sqldeveloper.exe", on Mac OS X or ARM64, you can double-click on the SQL Developer icon, on Linux RPM, you can double-click on "sqldeveloper.sh", etc.
When you start SQL Developer for the first time, you will see a splash screen followed by a welcome page. You can close the welcome page by clicking on the "X" button at the top right corner. You will then see the main window of SQL Developer, which consists of several panels and menus. You can customize the layout and appearance of the main window by dragging and dropping the panels, resizing them, hiding them, or showing them.
To connect to a database using SQL Developer, you need to create a connection. A connection is a set of information that identifies a database and allows you to access it. You can create multiple connections for different databases and switch between them easily. To create a connection, follow these steps:
Click on the green "+" button at the top left corner of the Connections panel. This will open the New/Select Database Connection dialog box.
Enter a name for your connection in the Connection Name field. This can be any name that helps you identify the connection.
Select a connection type from the Connection Type drop-down list. This can be Basic, TNS, LDAP, or Cloud PDB, depending on how you want to connect to the database.
Enter the username and password for your database account in the Username and Password fields. You can also check the Save Password box if you want to save your password for future use.
Enter the hostname or IP address of your database server in the Hostname field. This is the name or address of the machine where your database is running.
Enter the port number of your database server in the Port field. This is the number that identifies the communication channel between your machine and your database server. The default port number for Oracle Database is 1521.
Enter the service name or SID of your database in the Service Name or SID field. This is the name or identifier of your database instance on your database server.
Click on the Test button to test your connection. This will verify if your connection information is correct and if you can connect to your database successfully. You should see a message saying "Success" if everything is OK.
Click on the Connect button to connect to your database. This will close the dialog box and open a new worksheet in SQL Developer where you can run SQL statements and scripts against your database.
How to Update SQL Developer
To keep your SQL Developer up-to-date To keep your SQL Developer up-to-date, you can check for updates and apply them from within the tool. You can also download the latest version of SQL Developer from the OTN website and install it over your existing installation. The following steps will show you how to check for updates and apply them:
Click on the Help menu and select Check for Updates. This will open the Check for Updates wizard.
Select the "Search Update Center" option and click Next. This will search for available updates from the Oracle SQL Developer Update Center.
Select the updates that you want to install from the list of available updates and click Next. You can also select the "Select All" button to select all updates.
Review the license agreement for the selected updates and click Accept if you agree with the terms and conditions.
Click Finish to start downloading and installing the updates. This may take some time depending on your internet connection speed and the size of the updates.
Restart SQL Developer when prompted to complete the installation of the updates.
Conclusion
In this article, you have learned how to download SQL Developer for different platforms, how to start it, and how to update it. You have also learned some of the features and benefits of using SQL Developer for database development and management. SQL Developer is a free, easy-to-use, versatile, integrated, and compatible tool that can help you work with Oracle Database in both traditional and cloud deployments. You can use it to browse database objects, run SQL statements, edit and debug PL/SQL statements, run reports, perform database administration tasks, import and export data, compare schemas and data, tune queries, monitor performance, and more.
If you want to learn more about SQL Developer, you can visit the on the OTN website. There you can find user guides, tutorials, videos, blogs, forums, FAQs, and other resources that can help you get started and master SQL Developer.
We hope you have enjoyed this article and found it useful. If you have any questions or feedback, please feel free to leave a comment below. Thank you for reading!
FAQs
Here are some of the frequently asked questions about SQL Developer:
QuestionAnswer
What are the system requirements for SQL Developer?The system requirements for SQL Developer depend on your platform and JDK version. Generally, you need at least 1 GB of RAM (2 GB recommended) and 300 MB of disk space (500 MB recommended) to run SQL Developer. You also need a JDK 8 or JDK 11 installed on your machine. You can check the on the OTN website for more details.
How can I connect to Oracle Database Cloud Service using SQL Developer?You can connect to Oracle Database Cloud Service using SQL Developer by creating a Cloud PDB connection. To do this, you need to have an Oracle Cloud account and a database service instance provisioned in Oracle Cloud. You also need to download a wallet file that contains the security credentials for your database service instance. You can then use the wallet file to create a Cloud PDB connection in SQL Developer. You can follow the steps in this to learn how to connect to Oracle Database Cloud Service using SQL Developer.
How can I migrate my third-party database to Oracle Database using SQL Developer?You can migrate your third-party database to Oracle Database using SQL Developer by using the Migration Wizard. The Migration Wizard is a tool that guides you through the process of migrating your database objects, data, and applications from a third-party database (such as MySQL, SQL Server, Sybase ASE, DB2, or Teradata) to Oracle Database. You can follow the steps in this to learn how to migrate your third-party database to Oracle Database using SQL Developer.
How can I create and run reports using SQL Developer?You can create and run reports using SQL Developer by using the Reports interface. The Reports interface is a tool that allows you to create custom reports based on SQL queries or PL/SQL code. You can also use predefined reports that are provided by SQL Developer or imported from other sources. You can run reports in different formats, such as HTML, PDF, XML, CSV, etc. You can also schedule reports to run automatically at specified intervals or events. You can follow the steps in this to learn how to create and run reports using SQL Developer.
How How can I use SQL Developer with Oracle Application Express (APEX)?You can use SQL Developer with Oracle Application Express (APEX) by using the APEX interface. The APEX interface is a tool that allows you to access and manage your APEX applications and workspaces from within SQL Developer. You can also use SQL Developer to create and edit APEX applications, pages, regions, items, processes, etc. You can follow the steps in this to learn how to use SQL Developer with Oracle Application Express (APEX).
44f88ac181
Kommentare