How to Install and Use PL/SQL Developer 64-bit on Windows
PL/SQL Developer is a popular and powerful integrated development environment (IDE) for Oracle Database. It offers many features and tools to help you write, debug, and optimize PL/SQL code, as well as manage database objects, data, and users. PL/SQL Developer supports both 32-bit and 64-bit versions of Windows, but you need to download and install the appropriate version for your system. In this article, we will show you how to install and use PL/SQL Developer 64-bit on Windows.
Before you can install and use PL/SQL Developer 64-bit on Windows, you need to have the following prerequisites:
An Oracle Database server that you can connect to. You can use any version of Oracle Database from 11gR2 to 21c, either on-premises or in the cloud. You can also use Oracle Autonomous Database or Oracle Database Express Edition (XE) for free.
An Oracle client software that matches the bit level of your Windows system. You can use either Oracle Instant Client or Oracle Database Client. You can download them from [Oracle Technology Network].
A Java Development Kit (JDK) that matches the bit level of your Windows system. You can use either Oracle JDK 8 or 11. You can download them from [Oracle Technology Network].
Once you have the prerequisites ready, you can follow these steps to install PL/SQL Developer 64-bit on Windows:
Download the PL/SQL Developer 64-bit installer from [Oracle SQL Developer Downloads]. You can choose either the version with JDK 11 included or the version without JDK. If you choose the latter, make sure you have JDK installed on your system.
Run the installer and follow the instructions on the screen. You can accept the default settings or customize them as you wish.
After the installation is complete, launch PL/SQL Developer from the Start menu or the desktop shortcut.
The first time you run PL/SQL Developer, it will ask you to enter the path to your JDK home directory. You can browse to the location where you installed JDK or enter it manually. A valid JDK home on Windows will be similar to C:\Program Files\Java\jdk-11.0.11.
PL/SQL Developer will also ask you to create a new connection to your Oracle Database server. You can enter the connection details such as hostname, port, service name, username, and password. You can also test the connection before saving it.
Once you have created a connection, you can start using PL/SQL Developer to work with your Oracle Database.
Features and Benefits
PL/SQL Developer 64-bit offers many features and benefits for Oracle Database developers and administrators, such as:
A full-featured PL/SQL IDE that allows you to write, compile, run, debug, and optimize PL/SQL code. You can also use code templates, snippets, formatting, refactoring, code analysis, code insight, code beautifier, and other tools to improve your productivity and code quality.
A worksheet for running SQL queries and scripts. You can also use SQL commands, bind variables, substitution variables, command history, output formatting, result grid, explain plan, autotrace, and other features to work with data efficiently.
A DBA console for managing database objects, data, and users. You can also use wizards, dialogs, property sheets, reports, browsers, editors, and other tools to perform common tasks such as creating tables, indexes, views, triggers, procedures, functions, packages, users, roles, privileges, etc.
A reports interface that allows you to create and run various types of reports based on SQL queries or predefined templates. You can also export or print the reports in different formats such as HTML, PDF, CSV, XML, etc.
A complete data modeling solution that allows you to design logical and physical data models using entity relationship diagrams (ERDs). You can also generate DDL scripts from the models or reverse engineer existing database schemas into models.
A migration platform that allows you to migrate your 3rd party databases to Oracle Database. You can also use SQL Developer to migrate your Oracle Database on-premises to Oracle Cloud.
PL/SQL Developer 64-bit is a powerful and versatile tool for Oracle Database development and administration. It supports both 32-bit and 64-bit versions of Windows, but you need to download and install the appropriate version for your system. You also need to have an Oracle Database server, an Oracle client software, and a JDK installed on your system. Once you have installed PL/SQL Developer 64-bit, you can use it to write, debug, and optimize PL/SQL code, run SQL queries and scripts, manage database objects, data, and users, create and run reports, design and generate data models, and migrate your 3rd party databases to Oracle Database.