B execute your procedure using the value 5 for the

This preview shows page 4 - 7 out of 7 pages.

B. Execute your procedure using the value 5 for the region_id and 2000 for the highest elevation. C. DESCRIBE your procedure to check the names and datatypes of its formal parameters.
D. Retrieve your procedure code from Saved SQL and modify it to accept a third formal parameter of datatype CHAR. The procedure should display a count of the number of countries in a given region whose highest elevations exceed a given value and whose country name starts with a given alphabetic character. Your SELECT statement should include a WHERE condition to compare the first character of each country’s name with the third parameter value (Hint: use SUBSTR). Save your work again and DESCRIBE the modified procedure.
E. Write an anonymous block which declares three variables to store actual parameter values for the region_id, elevation, and area, and then executes the procedure passing these values.
F. Modify your anonymous block to use the same actual parameter values but pass them to the procedure in a different order: (5, ‘B’, 2000). Execute the block. What happens and why?
Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture