PLSQL_8_3_Practice- Viju.docx - academy.oracle.com Database...

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

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
Positional Lists the actual parameters in the same order as the formal parameters
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? IN****, OUT, IN OUT 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