Summary
In this chapter, you learned about PL/SQL architecture and how it may be used in a multitier environment. You also learned how PL/SQL can interact with users via substitution variables and the DBMS_OUTPUT.PUT_LINE statement. Finally, you learned about two PL/SQL development tools—SQL Developer and SQL*Plus. The examples shown in this chapter were executed in both tools to illustrate the differences between them. The main difference between the two is that SQL Developer has a graphical user interface and SQL*Plus has a command-line interface. The PL/SQL examples used throughout this book may be executed in either tool with the same results. Depending on your preference, you may choose one tool over the other. However, it is a good idea to become familiar with both, as these tools are part of almost every Oracle database installation.