PLSQL_8_3_Practice.docx - www.oracle.com/academy Database...

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

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Understanding Health Insurance: A Guide to Billing and Reimbursement
The document you are viewing contains questions related to this textbook.
Chapter 7 / Exercise 6
Understanding Health Insurance: A Guide to Billing and Reimbursement
Green
Expert Verified
Database Programming with PL/SQL 8-3: Passing Parameters Practice Activities Vocabulary Identify the vocabulary word for each definition below: OUT parameter Returns a value to the caller IN parameter Provides values for a subprogram to process Named Lists the actual parameters in arbitrary order and uses the association operator ( ‘=>' which is an equal and an arrow together) to associate a named formal parameter with its actual parameter Combination Lists some of the actual parameters as positional (no special operator) and some as named (with the => operator) Positional Lists the actual parameters in the same order as the formal parameters IN OUT PARAMETER Supplies an input value, which may be returned as a modified value Try It / Solve It 1. Name the three modes for parameters and indicate which mode is the default mode. Which mode cannot be modified inside the procedure?
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Understanding Health Insurance: A Guide to Billing and Reimbursement
The document you are viewing contains questions related to this textbook.
Chapter 7 / Exercise 6
Understanding Health Insurance: A Guide to Billing and Reimbursement
Green
Expert Verified
2 2. Procedures: A. Create a procedure that receives a country_id as an IN parameter and returns the name and population of that country as OUT parameters. Include an exception handler to trap the NO_DATA_FOUND exception if the country does not exist. The procedure should not display the returned values; this will be done in the next step. Name your procedure find_area_pop. Save your code.
B. Test your procedure by creating and executing an anonymous block which invokes the procedure and displays the returned OUT values. Save your code. Run the block twice, with country_ids 2 (Canada) and 10 (does not exist).

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture