|
|
|
In this module, you learned about 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:
-
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
Glossary 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
In the next module, you will learn in detail about datatypes.
|
