Oracle® PL/SQL® Interactive Workbook, Second Edition

Lab 3.1 PL/SQL Programming Fundamentals

Lab Objectives After this Lab, you will be able to: ✓ Make Use of PL/SQL Language Components ✓ Make Use of PL/SQL Variables ✓ Handle PL/SQL Reserved Words ✓ Make Use of Identifiers in PL/SQL ✓ Make Use of Anchored Data types ✓ Declare and Initialize Variables ✓ Understand the Scope of a Block, Nested Blocks, and Labels

In most languages, you have only two sets of characters: numbers and letters. Some languages, such as Hebrew or Tibetan, have specific characters for vowels that are not placed in line with consonants. Additionally, other languages, such as Japanese, have three character sets: one for words originally taken from the Chinese language, another set for native Japanese words, and then a third for ...