The PL/SQL Development Cycle - Exercise

Contact Us or call 1-877-932-8228
The PL/SQL Development Cycle - Exercise

The PL/SQL Development Cycle

Duration: 10 to 15 minutes.
  1. Configure a connection (if necessary) to the database that contains the HR schema that will be used for the class.
  2. Make a connection using client software (SQL Developer and/or SQL*Plus) using the HR user.
  3. Create and execute a call to a stored procedure that will print out "Hello Universe!" using the execute command.


exec dbms_output.put_line('Hello Universe!');

Code Explanation

Up to this point, you might have been typing in text (or copying/pasting) into SQL Developer. The following involves opening an existing file and figuring out how to associate a connection. This is an important concept for understanding the basic development process that is required for PL/SQL Development (as well as exercises for the remainder of this course).


  1. Open a script that contains all of the commands from the previous exercise using The File - Open menu options. Run the script, change the text being displayed to standard out to "Hello Friend".

Challenge Solution:

-- Is the run menu disabled?  If so, make sure that you
-- assign the new worksheet to a connection using the
-- dropdown on the right hand side of the new
-- worksheet's tool bar.

exec dbms_output.put_line('Hello Friend!');

Code Explanation