SQL Developer Download 21: How to Install and Use Oracle's Free IDE for Database Development and Management
If you are looking for a free, integrated development environment (IDE) that simplifies the development and management of Oracle Database, you might want to check out SQL Developer. SQL Developer is a Java-powered application for Windows, OS X, Linux, and ARM64 platforms that offers a full-featured PL/SQL IDE, database administration, data modeling, migrations, and more. In this article, we will show you how to download, install, and run SQL Developer 21, the latest version of this popular tool.
What is SQL Developer and why use it?
SQL Developer is a tool that helps you work with Oracle Database in various ways. You can use it to create, edit, debug, and run PL/SQL code, as well as browse, query, export, import, and manipulate data. You can also use it to perform database administration tasks such as creating users, roles, tablespaces, indexes, constraints, triggers, views, synonyms, sequences, etc. You can also use it to design and generate data models, compare and synchronize schemas and data, migrate data from other database systems to Oracle, and more.
sql developer download 21
SQL Developer features and benefits
Some of the main features and benefits of SQL Developer are:
It is free to download and use for both personal and commercial purposes.
It supports Oracle Database versions from 9i to 21c, as well as Oracle Cloud Database Services.
It has a user-friendly graphical user interface (GUI) that allows you to work with multiple database connections, files, worksheets, reports, etc. in a tabbed interface.
It has a powerful code editor that supports syntax highlighting, code completion, code formatting, code snippets, code templates, code folding, code refactoring, error checking, debugging, etc.
It has a built-in SQL*Plus command-line interface that allows you to execute SQL and PL/SQL commands directly.
It has a built-in database browser that allows you to view and manipulate database objects such as tables, views, indexes, triggers, etc. in a tree structure.
It has a built-in data viewer that allows you to view and edit data in tables and views in a grid or form layout.
It has a built-in data exporter and importer that allows you to export and import data in various formats such as CSV, XML, JSON, Excel, HTML, PDF, etc.
It has a built-in data modeler that allows you to create logical and physical data models using entity-relationship diagrams (ERDs), reverse engineer existing schemas into models, generate DDL scripts from models, compare and synchronize models with schemas or other models,
It has a built-in migration tool that allows you to migrate data from other database systems such as MySQL,
SQL Server, Sybase, Access, etc. to Oracle Database using a wizard-based interface.
It has a built-in reporting tool that allows you to create and run various reports on database objects, data, performance, etc. using predefined or custom templates.
It has a built-in tuning tool that allows you to monitor and optimize the performance of SQL statements, PL/SQL code, database instances, etc. using advisors, profilers, tracers, etc.
It has a built-in testing tool that allows you to create and run unit tests and code coverage for PL/SQL code using the SQL Developer Unit Testing framework.
It has a built-in version control tool that allows you to integrate with various version control systems such as Git, Subversion, CVS, etc. and manage your code changes.
It has a built-in extension manager that allows you to install and update various extensions that enhance the functionality of SQL Developer.
SQL Developer system requirements and compatibility
To run SQL Developer 21, you need the following system requirements:
sql developer 21.2 download
oracle sql developer 21.4.1 download
sql developer 21 installation guide
sql developer 21 with jdk 8 included
sql developer 21 for mac os x
sql developer 21 linux rpm download
sql developer 21 release notes
sql developer 21 bugs fixed
sql developer 21 documentation
sql developer 21 command line
sql developer 21 free use license
sql developer 21 new features
sql developer 21 tutorial
sql developer 21 system requirements
sql developer 21 performance tuning
sql developer 21 data modeler
sql developer 21 migration assistant
sql developer 21 rest data services
sql developer 21 unit testing
sql developer 21 data pump
sql developer 21 export to excel
sql developer 21 import from csv
sql developer 21 connect to oracle database
sql developer 21 connect to mysql database
sql developer 21 connect to postgresql database
sql developer 21 connect to mssql database
sql developer 21 connect to sqlite database
sql developer 21 connect to db2 database
sql developer 21 connect to teradata database
sql developer 21 connect to snowflake database
sql developer 21 query builder
sql developer 21 code editor
sql developer 21 code formatter
sql developer 21 code completion
sql developer 21 code snippets
sql developer 21 code templates
sql developer 21 code refactoring
sql developer 21 code debugging
sql developer 21 code generation
sql developer 21 code review
sql developer 21 pl/sql support
sql developer 21 json support
sql developer 21 xml support
sql developer 21 spatial support
sql developer 21 graph support
sql developer 21 version control integration
sql developer 21 extensions and plugins
sql developer 21 user interface customization
sql developer 21 keyboard shortcuts
A computer with a minimum of 1 GB of RAM and 300 MB of disk space.
A Java Development Kit (JDK) version 8 or higher. You can download the JDK from .
An Oracle Database version 9i or higher. You can download the Oracle Database from . You can also use SQL Developer with Oracle Cloud Database Services such as Autonomous Database, Database Cloud Service, Exadata Cloud Service, etc.
SQL Developer 21 is compatible with the following platforms:
Windows 7 or higher (32-bit or 64-bit)
Mac OS X 10.13 or higher (64-bit)
Linux x86-64 (64-bit)
Linux ARM64 (64-bit)
How to download SQL Developer 21
To download SQL Developer 21, you need to follow these steps:
Choose the right version for your platform
SQL Developer 21 is available in four versions for different platforms:
Windows 32-bit/64-bit with JDK 8 included
Windows 32-bit/64-bit without JDK
Mac OS X 64-bit with JDK 8 included
Linux RPM 64-bit without JDK
Linux ARM64 64-bit without JDK
You need to choose the version that matches your platform and whether you have JDK installed or not. If you are not sure about your platform or JDK status, you can use the Windows version with JDK included, which will work on most Windows systems.
Download from Oracle's website
To download SQL Developer 21 from Oracle's website, you need to do the following:
Go to .
Select the Accept License Agreement option.
Select the download link for the version you want to download. You may need to sign in with your Oracle account or create one if you don't have one.
Save the downloaded file to your computer. The file name will be something like sqldeveloper-21.2.1.204.1704-x64.zip or sqldeveloper-21.2.1.204.1704-no-jre.zip depending on the version you chose.
Verify the checksum of the downloaded file
To ensure that the downloaded file is not corrupted or tampered with, you should verify its checksum using a tool such as MD5 or SHA-256. You can find the checksum values for each version on . To verify the checksum, you need to do the following:
Open a command prompt or terminal window on your computer.
Navigate to the folder where you saved the downloaded file.
Type the command md5sum or sha256sum followed by the file name and press Enter. For example: md5sum sqldeveloper-21.2.1.204.1704-x64.zip or sha256sum sqldeveloper-21.2.1.204.1704-no-jre.zip
Compare the output of the command with the checksum value on the download page. They should match exactly.
If the checksum values do not match, it means that the downloaded file is corrupted or tampered with, and you should download it again from a trusted source.
How to install SQL Developer 21
To install SQL Developer 21, you need to follow different steps depending on your platform. Here are the installation notes for each platform:
Windows installation notes
To install SQL Developer 21 on Windows, you need to do the following:
Unzip the downloaded file to a folder of your choice. For example: C:\sqldeveloper
Open the folder and double-click the sqldeveloper.exe file to launch the application.
If you downloaded the version without JDK, you may be prompted to enter a JDK path. You can browse to the location of your JDK installation or download and install JDK 8 or higher from .
Mac OS X and ARM64 installation notes
To install SQL Developer 21 on Mac OS X or ARM64, you need to do the following:
Unzip the downloaded file to a folder of your choice. For example: /Applications/sqldeveloper
Open the folder and double-click the SQLDeveloper.app file to launch the application.
If you downloaded the version without JDK, you may be prompted to enter a JDK path. You can browse to the location of your JDK installation or download and install JDK 8 or higher from .
Linux RPM installation notes
To install SQL Developer 21 on Linux RPM, you need to do the following:
Open a terminal window and navigate to the folder where you saved the downloaded file.
Type the command sudo rpm -ivh followed by the file name and press Enter. For example: sudo rpm -ivh sqldeveloper-21.2.1.204.1704-1.noarch.rpm
Type your password when prompted and wait for the installation to complete.
Type the command sqldeveloper to launch the application.
If you downloaded the version without JDK, you may be prompted to enter a JDK path. You can browse to the location of your JDK installation or download and install JDK 8 or higher from .
How to run SQL Developer 21
To run SQL Developer 21, you need to do the following:
Launch the application from the executable file or script
Depending on your platform, you can launch SQL Developer 21 by double-clicking the sqldeveloper.exe file on Windows, the SQLDeveloper.app file on Mac OS X or ARM64, or typing the command sqldeveloper on Linux RPM. You can also create a shortcut or alias for the executable file or script for easier access.
Enter a JDK path if prompted
If you downloaded the version without JDK, you may be prompted to enter a JDK path when you run SQL Developer 21 for the first time. You can browse to the location of your JDK installation or download and install JDK 8 or higher from . You can also change the JDK path later by editing the SetJavaHome parameter in the sqldeveloper.conf file located in the sqldeveloper/bin folder.
Connect to an Oracle database or use the built-in database features
Once you launch SQL Developer 21, you can connect to an Oracle database or use the built-in database features. To connect to an Oracle database, you need to do the following:
Click the New Connection icon on the Connections panel or select File > New > Database Connection from the menu.
Enter a name for the connection and select a connection type from the drop-down list. The connection type can be Basic, TNS, LDAP, Cloud Wallet, etc.
Enter the username and password for the database user and select a role from the drop-down list. The role can be Default, SYSDBA, SYSOPER, etc.
Enter the hostname, port number, and service name or SID of the database instance. You can also use a TNS name or an LDAP name if you have configured them.
Click Test to test the connection and click Save to save it.
Click Connect to connect to the database.
To use the built-in database features, you need to do the following:
Select View > DBA from the menu to open the DBA panel.
Select a connection from the drop-down list or create a new one as described above.
Expand the connection node and select a category such as Data Dictionary, Storage, Security, etc. to view and manage various database objects and settings.
Conclusion and FAQs
In this article, we have shown you how to download, install, and run SQL Developer 21, Oracle's free IDE for database development and management. SQL Developer 21 is a powerful and versatile tool that offers many features and benefits for working with Oracle Database. You can use it to create, edit, debug, and run PL/SQL code, browse, query, export, import, and manipulate data, perform database administration tasks, design and generate data models, compare and synchronize schemas and data, migrate data from other database systems to Oracle, create and run reports on database objects, data, performance, etc., monitor and optimize the performance of SQL statements, PL/SQL code, database instances, etc., create and run unit tests and code coverage for PL/SQL code, integrate with various version control systems and manage your code changes, install and update various extensions that enhance the functionality of SQL Developer, and more.
If you want to learn more about SQL Developer 21, you can visit . You can also check out some of the frequently asked questions (FAQs) below:
Q: How do I update SQL Developer 21?
A: To update SQL Developer 21, you can do one of the following:
Select Help > Check for Updates from the menu and follow the instructions.
Download the latest version from and install it over your existing installation.
Download the latest version from and unzip it to a new folder. You can then copy your user settings from your old installation folder (sqldeveloper/userdata) to your new installation folder (sqldeveloper/sqldeveloper/userdata).
Q: How do I uninstall SQL Developer 21?
A: To uninstall SQL Developer 21, you can do one of the following:
Delete the >li>Right-click on various panels, tabs, toolbars, etc. to access the context menu, where you can change various options such as docking, floating, hiding, closing, etc.
Q: How do I extend SQL Developer 21?
A: To extend SQL Developer 21, you can do one of the following:
Select Help > Check for Updates from the menu to access the update manager, where you can install and update various extensions that enhance the functionality of SQL Developer.
Select Tools > Features from the menu to access the feature manager, where you can enable or disable various features that are included in SQL Developer.
Select Tools > Manage Database Extensions from the menu to access the extension manager, where you can create and manage custom extensions for database objects such as tables, views, indexes, etc.
Visit , where you can download and install various extensions that are created by Oracle and the SQL Developer community.
Visit , where you can learn how to create your own extensions using the SQL Developer Extension SDK.
44f88ac181
Comments