Lesson 8
Building Queries with PL-SQL Conclusion
This module discussed the tools that you to use to build your queries with PL/SQL. Then you learned about the
different variable types that are used within PL/SQL. Further, you enhanced your knowledge of non-PL/SQL bind and host
variables.
You also reviewed the DBMS_OUTPUT.PUT_LINE package procedure to display the output to your screen. Finally, you learned the importance of using standard naming conventions while writing your code.
In this module, you learned how to:
You also reviewed the DBMS_OUTPUT.PUT_LINE package procedure to display the output to your screen. Finally, you learned the importance of using standard naming conventions while writing your code.
- Define the term PL/SQL and describe some of the common tools used to develop PL/SQL
- Identify different types of variables
- Identify variable datatypes
- Use the non-PL/SQL bind and host variables to manipulate data within SQL*Plus
- Use the DBMS_OUTPUT.PUT_LINE package procedure to display values to the SQL*Plus screen
- Illustrate the importance of naming conventions for application code
In this module you were introduced to the following glossary terms:
- Block
- code walkthrough
- Global: Globals do not respect the boundaries of program interfaces. You can read and write globals without using the parameter list of a module.
- Package: A database program consisting of one or more procedures. A package executes when called using SQL or a programming language interface.
- Procedure
- Runtime
