PL/SQL Developer is a powerful and easy-to-use integrated development environment for Oracle Database. It offers features such as a PL/SQL editor, a worksheet for running queries and scripts, a DBA console for managing the database, a data modeler, and a migration tool for moving your third-party databases to Oracle.
In this article, we will show you how to install and use PL/SQL Developer 9.0.6.1665 on Windows. This version was released on September 12, 2022 and includes bug fixes and enhancements[^2^].
You can download PL/SQL Developer 9.0.6.1665 from the official website of Oracle[^1^]. There are two downloads available for Windows users:
We recommend using the first option as it is easier and faster to set up.
After extracting the zip file, you can run PL/SQL Developer by double-clicking the sqldeveloper.exe file in the top directory. You will see a splash screen and then a welcome page.
If you are using the second option, you may be prompted to enter a JDK path. A valid Java Home on Windows will be similar to C:\\Program Files\\Java\\jdk-11.0.11.
To start working with PL/SQL Developer, you need to connect to an Oracle Database. You can do this by clicking the Connect button on the toolbar or by selecting File > New > Connection.
You will see a dialog box where you can enter the connection details such as the username, password, database name, host name, port number, and service name or SID. You can also choose the connection type (Basic, TNS, LDAP, etc.) and test the connection before saving it.
Once you have created a connection, you can see it in the Connections window on the left side of the main window. You can expand it to see the database objects such as tables, views, procedures, functions, packages, etc.
PL/SQL Developer offers many features that help you develop and manage your Oracle Database applications. Here are some of them:
You can access these features from the menu bar or the
ea27c8ed11