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
Database Programming with PL/SQL
Using Parameters in Procedures
Yashub Armando Guzman Espinoza 1630123
Identify the vocabulary word for each definition below:
Pass or communicate data between the caller and subprogram.
The actual value assigned to a parameter.
Can be literal values, variables, or expressions that are provided in
the parameter list of a called subprogram.
A parameter name declared in the procedure heading.
Try It / Solve It
In your own words, describe parameters and the purpose they serve in PL/SQL subprograms.
2. Using the COUNTRIES table:
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.