A Create a procedure that accepts a country_id as a...

This preview shows page 1 - 2 out of 5 pages.

Copyright © 2018, 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. Database Programming with PL/SQL 8-2: Using Parameters in Procedures Yashub Armando Guzman Espinoza 1630123 Practice Activities Vocabulary Identify the vocabulary word for each definition below: Parameters Pass or communicate data between the caller and subprogram. Actual Parameter The actual value assigned to a parameter. argument Can be literal values, variables, or expressions that are provided in the parameter list of a called subprogram. Formal parameter A parameter name declared in the procedure heading. Try It / Solve It 1. In your own words, describe parameters and the purpose they serve in PL/SQL subprograms. 2. Using the COUNTRIES table: A. Create a procedure that accepts a country_id as a parameter and displays the name of the country and its capitol city. Name your procedure get_country_info. Save your procedure definition for later use.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture