Setting up environment to run PL/SQL

This sections shows how to setup an environment to setup and run PL/SQL. For PL/SQL, you need to download two pieces of software freely available from Oracle.

First, download Oracle Express Edition. It is a lighter version of Oracle, good enough for non-enterprise level work. In addition, it is a much smaller download.

1. Download Oracle Express Edition
2. Unzip
3. Double-click on setup.exe
4. Follow instructions. It will ask you for a password. Write this password or memorize it.

When installation is complete, start the software. You will be prompted for a username and password.

Your username is SYS
Your password is whatever you typed during installation

Next, download and installsqldeveloper.

  1. Download sqldeveloper
  2. copy the zip file to c:\Program Files. Then unzip. If you cannot unzip, unzip outside c:\Program Files and then copy the entire directory inside c:\Program Files
  3. Double-click on the sqldeveloper.exe to run the application