This course starts off by introducing you to PL/SQL and the tools that you can use to build your queries with PL/SQL. Then you will learn about the different variable types that are used within PL/SQL. You will also enhance your knowledge of non-PL/SQL bind and host variables.
You will also learn about the DBMS_OUTPUT.PUT_LINE package procedure to display the output to your screen. Finally, you will review some of the recommended naming conventions for application code.

By the end of this module, you will know how to:

1. Define the term PL/SQL and describe some of the common tools used to develop PL/SQL
   
2. Identify different types of variables
   
3. Identify variable datatypes
   
4. Use the non-PL/SQL bind and host variables to manipulate data within SQL*Plus
   
5. Use the DBMS_OUTPUT.PUT_LINE package procedure to display values to the SQL*Plus screen
   
6. Illustrate the importance of naming conventions for application code