The PL/SQL Development Cycle
Duration: 10 to 15 minutes.
- Configure a connection (if necessary) to the database that contains the HR schema that will be used for the class.
- Make a connection using client software (SQL Developer and/or SQL*Plus) using the HR user.
- 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!');
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).
- 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".
-- 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!');