100%(5)5 out of 5 people found this document helpful
This preview shows page 1 - 5 out of 18 pages.
LESSON 2 HOMEWORK 1Database Programming with PL/SQL 2-1: Using Variables in PL/SQLPractice Activities Vocabulary Identify the vocabulary word for each definition below: Variables Used for storage of data and manipulation of stored values. Parameters Values passed to a program by a user or by another program to customize the program. Try It / Solve It 1.Fill in the blanks. A.Variables can be assigned to the output of a subprogram B.Variables can be assigned values in the declarative section of a PL/SQL block. C.Variables can be passed as parameters to subprograms. 2.Identify valid and invalid variable declaration and initialization:
LESSON 2 HOMEWORK 35.Write an anonymous block that uses a country name as input and prints the highest and lowest elevations for that country. Use the COUNTRIES table. Execute your block three times using United States of America, French Republic, and Japan.