Answer Happy

Question 2.
The codes are as to be written in oracle sql developer for
question 2
INTODUCTION TO PL/SQL Lesson A 1. Write program commands to declare a numert var able named counter and a variable-length character string variable memy_string. Assign the value 100 to counter, and the text "Hello Work to my string, and display the values on two separate lines. Save the as 3ACase 1.sql. 2. Write program commands to declare the following variables and assign to them the given values: Variable name Data type Value Inventory ID Numeric 1 Inventory_color Character Sky Blue Inventory_Price Numeric 259.99 Inventory_QOH Numeric 16 Write commands that use the variables to display the output exactly as shown below. Save the file as 3ACase2.sql. Do not insert, or hard-code, the actual data values in the output procedure. Inventory ID : 1 Color: Sky Blue Price: $259.99 Quantity on Hand: 16 PLISQL procedure successfully completed. 3. Write commands to declare the following variables and assign to them the given values. Select an appropriate PLISQL data type for each variable. Variable Name Student_last_name Student_first_name Student_MI Student address Sudent_city Student state Student z Data Type ? ? ? ? ? 2 Value Miller Sarah M 144 Windridge Blvd. Eau Claire