Identify the vocabulary word for each definition below:

  • No School
  • AA 1
  • skippy656
  • 4
  • 100% (7) 7 out of 7 people found this document helpful

This preview shows page 1 - 3 out of 4 pages.

Database Programming with PL/SQL 8-2: Using Parameters in Procedures Practice Activities Vocabulary Identify the vocabulary word for each definition below: Parameter 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 Argument 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.
IS BEGIN SELECT country_id, capitol, country_name INTO p_capitol, p_name FROM wf_countries WHERE country_id=p_id; END; B.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture