Oracle SQL Developer 21: The Ultimate Database IDE for Oracle Users

How to Download Oracle SQL Developer 21

If you are looking for a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and cloud deployments, you should consider Oracle SQL Developer 21. In this article, we will show you how to download and install this powerful tool on different operating systems, and how to use its features to work with your Oracle database better and faster.

download oracle sql developer 21

Download Zip

What is Oracle SQL Developer 21?

A brief introduction to the tool and its features

Oracle SQL Developer is a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; migrate third-party databases to Oracle; view metadata and data in MySQL and other databases; and view and create reports. It supports Oracle Database versions 11gR2, 19c, and 21c, as well as Oracle Database in the cloud and on-premises. It also supports Oracle JDK versions 8 or 11.

Oracle SQL Developer has three interfaces: desktop, browser, and command line. You can choose the one that suits your needs and preferences. Some of the major features of Oracle SQL Developer are:

• Full-featured PL/SQL IDE

• Database administration

• Complete data modeling solution

• Third-party DBMS migrations to Oracle

• Migrate Oracle on-premises to Oracle cloud

• Query builder

• Code insight

• Refactoring

• Data miner

• Data modeler

• Unit testing

• REST data services

The benefits of using Oracle SQL Developer 21

Using Oracle SQL Developer 21 can bring you many benefits, such as:

• It is free and easy to install.

• It is compatible with different operating systems and platforms.

• It has a user-friendly and customizable interface.

• It has many features that can help you work with your Oracle database more efficiently and effectively.

• It can help you learn Oracle SQL and PL/SQL better.

• It can help you migrate your data from other databases to Oracle.

• It can help you create and share beautiful and interactive reports.

• It can help you troubleshoot and optimize your database performance.

How to Install Oracle SQL Developer 21 on Windows

The prerequisites and requirements for installation

To install Oracle SQL Developer 21 on Windows, you need to have:

• A computer running Windows OS (32-bit or 64-bit).

A JDK installed (version 8 or 11). You can download it from The steps to download and install the tool

To download and install Oracle SQL Developer 21 on Windows, you need to follow these steps:

download oracle sql developer 21.2

download oracle sql developer 21.4

download oracle sql developer 21.2.1

download oracle sql developer 21 for windows

download oracle sql developer 21 for mac

download oracle sql developer 21 for linux

download oracle sql developer 21 with jdk

download oracle sql developer 21 rpm

download oracle sql developer 21 zip

download oracle sql developer 21 documentation

download oracle sql developer 21 release notes

download oracle sql developer 21 bugs fixed

download oracle sql developer 21 installation guide

download oracle sql developer 21 command line

download oracle sql developer 21 free use license

download oracle sql developer 21 latest version

download oracle sql developer 21 update

download oracle sql developer 21 tutorial

download oracle sql developer 21 new features

download oracle sql developer 21 data modeler

download oracle sql developer 21 migration workbench

download oracle sql developer 21 rest data services

download oracle sql developer 21 dba panel

download oracle sql developer 21 unit testing

download oracle sql developer 21 code insight

download oracle sql developer 21 query builder

download oracle sql developer 21 debugger

download oracle sql developer 21 formatter

download oracle sql developer 21 reports

download oracle sql developer 21 extensions

download oracle sql developer 21 dark mode

download oracle sql developer 21 git integration

download oracle sql developer 21 docker support

download oracle sql developer 21 json editor

download oracle sql developer 21 spatial viewer

download oracle sql developer 21 graph visualization

download oracle sql developer 21 performance tuning

download oracle sql developer 21 pl/sql profiler

download oracle sql developer 21 database diff

download oracle sql developer 21 schema compare

download oracle sql developer 21 data pump export/import wizard

download oracle sql developer 21 cart feature

download oracle sql developer 21 connection manager

download oracle sql developer 21 cloud support

download oracle sql developer 21 autonomous database support

download oracle sql developer 21 always free tier support

download oracle sql developer 21 object browser

download oracle sql developer 21 worksheet

download oracle sql developer 21 snippets

• Go to the Oracle SQL Developer Downloads page and choose the download option that matches your system. For example, if you have a 64-bit Windows OS and you want to use the embedded JDK, you can choose the Windows 64-bit with JDK 8 included option.

• Save the zip file to your preferred location and extract it to a new folder. For example, you can extract it to C:\sqldeveloper.

• Open the folder where you extracted the files and double-click the sqldeveloper.exe file to launch the tool. If this is the first time you run the tool, it will prompt you to enter the full path to java.exe. You can either browse to the location of the embedded JDK (for example, C:\sqldeveloper\jdk\bin\java.exe) or enter the path to another JDK that you have installed on your system (for example, C:\Program Files\Java\jdk1.8.0_181\bin\java.exe).

• Click OK to start Oracle SQL Developer 21. You will see the splash screen and then the main window of the tool.

How to customize and configure the tool

Once you have installed Oracle SQL Developer 21 on Windows, you can customize and configure it according to your preferences and needs. Some of the things you can do are:

• Change the look and feel of the tool by choosing a different theme, font size, color scheme, and layout from the Tools menu.

• Enable or disable features and extensions from the Help menu.

• Set up your database connections by clicking the green plus icon in the Connections panel or by choosing File > New > Database Connection.

• Adjust your preferences for various aspects of the tool, such as code editor, database, debugger, formatter, migration, reports, etc. by choosing Tools > Preferences.

• Update your tool to the latest version by choosing Help > Check for Updates.

How to Install Oracle SQL Developer 21 on Mac OS X

The prerequisites and requirements for installation

To install Oracle SQL Developer 21 on Mac OS X, you need to have:

• A computer running Mac OS X (10.13 or later).

• A JDK installed (version 8 or 11). You can download it from .

The steps to download and install the tool

To download and install Oracle SQL Developer 21 on Mac OS X, you need to follow these steps:

• Go to the Oracle SQL Developer Downloads page and choose the download option for Mac OS X. For example, you can choose the Mac OS X 64-bit with JDK 8 included option.

• Save the dmg file to your preferred location and double-click it to mount it. You will see a window with the Oracle SQL Developer icon and a link to Applications.

• Drag and drop the Oracle SQL Developer icon to the Applications link to copy the tool to your Applications folder. Alternatively, you can copy the tool to any other folder on your system.

• Open the folder where you copied the tool and double-click the Oracle SQL Developer icon to launch the tool. You will see the splash screen and then the main window of the tool.

How to customize and configure the tool

Once you have installed Oracle SQL Developer 21 on Mac OS X, you can customize and configure it according to your preferences and needs. Some of the things you can do are:

• Change the look and feel of the tool by choosing a different theme, font size, color scheme, and layout from the SQL Developer menu.

• Enable or disable features and extensions from the Help menu.

• Set up your database connections by clicking the green plus icon in the Connections panel or by choosing File > New > Database Connection.

• Adjust your preferences for various aspects of the tool, such as code editor, database, debugger, formatter, migration, reports, etc. by choosing SQL Developer > Preferences.

• Update your tool to the latest version by choosing Help > Check for Updates.

How to Install Oracle SQL Developer 21 on Linux

The prerequisites and requirements for installation

To install Oracle SQL Developer 21 on Linux, you need to have:

• A computer running Linux OS (64-bit).

• A JDK installed (version 8 or 11). You can download it from .

The steps to download and install the tool

To download and install Oracle SQL Developer 21 on Linux, you need to follow these steps:

• Go to the Oracle SQL Developer Downloads page and choose the download option for Linux. For example, you can choose the Linux RPM (64-bit) option.

• Save the rpm file to your preferred location and open a terminal window. Navigate to the directory where you saved the file and run the following command to install the tool: sudo rpm -ivh sqldeveloper-21.2.0.187.1842-1.noarch.rpm

• Enter your password when prompted and wait for the installation to complete. You will see a message like this: Preparing... ################################# [100%] Updating / installing... 1:sqldeveloper-21.2.0.187.1842-1 ################################# [100%]

• To launch the tool, run the following command in the terminal: sqldeveloper. You will see the splash screen and then the main window of the tool.

How to customize and configure the tool

Once you have installed Oracle SQL Developer 21 on Linux, you can customize and configure it according to your preferences and needs. Some of the things you can do are:

• Change the look and feel of the tool by choosing a different theme, font size, color scheme, and layout from the Tools menu.

• Enable or disable features and extensions from the Help menu.

• Set up your database connections by clicking the green plus icon in the Connections panel or by choosing File > New > Database Connection.

• Adjust your preferences for various aspects of the tool, such as code editor, database, debugger, formatter, migration, reports, etc. by choosing Tools > Preferences.

• Update your tool to the latest version by choosing Help > Check for Updates.

How to Use Oracle SQL Developer 21

How to create and manage database connections

To use Oracle SQL Developer 21, you need to create and manage database connections that allow you to access and work with your Oracle database. To create a new database connection, you can follow these steps:

• Click the green plus icon in the Connections panel or choose File > New > Database Connection.

• In the New / Select Database Connection dialog box, enter a name for your connection and choose a connection type (such as Basic or TNS).

• Enter the username and password for your database account and specify the hostname, port number, SID or service name of your database.

• Click Test to verify that your connection details are correct and that you can connect to your database.

• Click Save to save your connection and add it to the Connections panel.

To manage your existing database connections, you can right-click on any connection in the Connections panel and choose from various options, such as Connect, Disconnect, Edit, Delete, Export, Import, etc.

How to execute SQL statements and scripts

To execute SQL statements and scripts in Oracle SQL Developer 21, you can use the SQL Worksheet or the SQL*Plus Worksheet. The SQL Worksheet allows you to enter and execute individual SQL statements or PL/SQL blocks, while the SQL*Plus Worksheet allows you to enter and execute SQL*Plus commands as well as SQL statements or PL/SQL blocks. To use either of these worksheets, you can follow these steps:

• Select a database connection from the Connections panel or create a new one if needed.

• Right-click on the connection and choose Open SQL Worksheet or Open SQL*Plus Worksheet.

• In the worksheet window, enter your SQL statement or script in the upper pane. You can use code insight, code completion, syntax highlighting, code formatting, etc. to help you write your code.

• To execute your code, click one of the buttons on the toolbar or use a keyboard shortcut. For example, you can click Run Statement (Ctrl+Enter) to execute a single statement or Run Script (F5) to execute multiple statements or a script.

• The results of your execution will be displayed in the lower pane. You can view them in different tabs, such as Query Result, Script Output, Explain Plan, etc.

How to edit and debug PL/SQL code

To edit and debug PL/SQL code in Oracle SQL Developer 21, you can use the PL/SQL Editor or the PL/SQL Debugger. The PL/SQL Editor allows you to create, edit, compile, and run PL/SQL code, such as procedures, functions, packages, triggers, etc. The PL/SQL Debugger allows you to debug your PL/SQL code by setting breakpoints, stepping through the code, inspecting variables, evaluating expressions, etc. To use either of these tools, you can follow these steps:

• Select a database connection from the Connections panel or create a new one if needed.

• Expand the connection node and navigate to the PL/SQL object that you want to edit or debug. For example, you can expand the Procedures node and select a procedure.

• Right-click on the object and choose Open or Debug.

• In the PL/SQL Editor or the PL/SQL Debugger window, you can edit or debug your code using various features and options. For example, you can use code insight, code completion, syntax highlighting, code formatting, compile errors, etc. to help you edit your code. You can also use breakpoints, step into, step over, step out, run to cursor, watch expressions, etc. to help you debug your code.

• To save and compile your changes, click the Save button on the toolbar or use a keyboard shortcut (Ctrl+S). To run your code, click the Run button on the toolbar or use a keyboard shortcut (Ctrl+Shift+F10).

How to migrate third-party databases to Oracle

To migrate third-party databases to Oracle in Oracle SQL Developer 21, you can use the Migration Wizard or the Migration Workbench. The Migration Wizard allows you to perform a quick and easy migration of a third-party database to Oracle by following a series of steps. The Migration Workbench allows you to perform a more advanced and customized migration of a third-party database to Oracle by using various tools and options. To use either of these tools, you can follow these steps:

• Select a database connection from the Connections panel or create a new one if needed.

• Right-click on the connection and choose Migrate or Migration Workbench.

• In the Migration Wizard or the Migration Workbench window, you can migrate your third-party database to Oracle using various features and options. For example, you can use source database capture, data move and load, target database generation, data verification, etc. to help you migrate your database.

• To start the migration process, click the Finish button on the Migration Wizard or the Start Migration button on the Migration Workbench.

How to create and share reports

To create and share reports in Oracle SQL Developer 21, you can use the Reports panel or the Report Editor. The Reports panel allows you to view and run predefined reports or create your own custom reports using SQL queries or PL/SQL code. The Report Editor allows you to design and edit your custom reports using various components and properties. To use either of these tools, you can follow these steps:

• Select a database connection from the Connections panel or create a new one if needed.

• Expand the Reports node in the Connections panel and navigate to the report that you want to view or create. For example, you can expand the Data Dictionary Reports node and select a report.

• Right-click on the report and choose Run Report or Edit Report.

• In the Reports panel or the Report Editor window, you can view or create your report using various features and options. For example, you can use filters, parameters, charts, grids, layouts, etc. to help you view or create your report.

• To save your report, click the Save button on the toolbar or use a keyboard shortcut (Ctrl+S). To export your report to various formats (such as PDF, HTML, XML, CSV, etc.), click the Export button on the toolbar or use a keyboard shortcut (Ctrl+Shift+E).

Conclusion

In this article, we have shown you how to download and install Oracle SQL Developer 21 on different operating systems (Windows, Mac OS X, and Linux), and how to use its features to work with your Oracle database better and faster. We have covered the following topics: - What is Oracle SQL Developer 21 and what are its benefits? - How to install Oracle SQL Developer 21 on Windows, Mac OS X, and Linux? - How to create and manage database connections? - How to execute SQL statements and scripts? - How to edit and debug PL/SQL code? - How to migrate third-party databases to Oracle? - How to create and share reports? We hope that this article has helped you learn how to download and use Oracle SQL Developer 21, a free and powerful tool for working with Oracle databases. If you have any questions or feedback, please feel free to leave a comment below. FAQs

Q: Where can I download Oracle SQL Developer 21?

A: You can download Oracle SQL Developer 21 from the Oracle SQL Developer Downloads page. You can choose the download option that matches your system and preferences.

Q: Do I need a license to use Oracle SQL Developer 21?

A: No, you do not need a license to use Oracle SQL Developer 21. It is a free tool that does not require any registration or activation. However, you do need a license to use Oracle Database, which is the target of Oracle SQL Developer 21.

Q: What are the system requirements for Oracle SQL Developer 21?

A: The system requirements for Oracle SQL Developer 21 vary depending on the operating system and platform. In general, you need a computer running Windows OS (32-bit or 64-bit), Mac OS X (10.13 or later), or Linux OS (64-bit), and a JDK installed (version 8 or 11). You also need an internet connection to download the tool and access online resources.

Q: How can I update Oracle SQL Developer 21 to the latest version?

A: You can update Oracle SQL Developer 21 to the latest version by choosing Help > Check for Updates from the menu bar. You will see a dialog box that shows you the available updates and allows you to select and install them.

Q: How can I get help and support for Oracle SQL Developer 21?

A: You can get help and support for Oracle SQL Developer 21 by using various resources, such as:

• The online documentation that provides detailed information and instructions on how to use the tool.

• The online forum that allows you to ask questions and get answers from other users and experts.

• The online blog that provides tips, tricks, news, and insights on how to use the tool.

• The online videos that demonstrate how to use the tool and its features.

44f88ac181