Title: Hands-On Practice Assignment - Chapter 3
Course: Introduction to Oracle SQL and PL/SQL (10610) > Section: Competency Modules

See Pages 119 - 122 -- required supporting files are provided by your instructor.

This assignment includes:

3-1 Querying Data in a Block

3-2  Using a Record Variable

3-3  Processing Database Data with   IF  statement

3-4  Using Searched  CASE  statements

3-5 Using a WHILE   Loop

3-6 Working with  IF  statements

3-7 Using Scalar  Variables  for Data Retreieval

3-8 Using a Record Variable for Data Retrieval

After assignment is completed -- please use the "Browse My Computer" feature and attach and upload completed work.

The solution will be provided by your instructor after submission.