RelationalDBDesign
prev next prev next
  Course navigation
 
Lesson 8
PL SQL Block Conclusion
    This module discussed how to write your first PL/SQL block, nested blocks, identifiers, and literals that help you build the program logic.
In this module, you also discovered the various datatype conversion functions as well as the use of operators in PL/SQL. Remember, it is extremely important to indent and comment your code.
In this module, you learned how to:
  1. Describe the basic structure of a PL/SQL block
  2. Define the scope of variables within nested blocks
  3. Place identifiers and use literals within a PL/SQL block
  4. Add comments to a PL/SQL block
  5. Identify implicit and explicit datatype conversions within PL/SQL
  6. Use operators within PL/SQL
PL/SQL Block Glossary
In this module, you were introduced to the following glossary terms:
  1. Block
  2. Datatype
  3. Identifier
  4. Literal
  5. Operator
  6. Reserved word
  7. Subprogram
  8. Truth table
In the next module, you will learn to add control statements to a PL/SQL block.
PL/ SQL DataTypes - Quiz
Click the Quiz button to take a multiple-choice quiz about the material we covered in this module.
PL/ SQL DataTypes - Quiz
  Course navigation