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 ...

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial