pdfcoffee.com_plsql-8-3-practice-pdf-free.pdf -...

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

The preview shows page 1 - 3 out of 6 pages.
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/respective owners. or its affiliates. Other names may be trademarks of theirJESUS EMANUEL GALVAN DIAZ 1630353Database Programming with PL/SQL8-3:Passing ParametersPractice ActivitiesVocabularyIdentify the vocabulary word for each definition below:OUT ParameterReturns a value to the callerIN ParameterProvides values for a subprogram to processNamed NotationLists the actual parameters in arbitrary order and uses the associationoperator ( ‘=>' which is an equal and an arrow together) to associate anamed formal parameter with its actual parameterCombination NotationLists some of the actual parameters as positional (no special operator)and some as named (with the => operator)Positional NotationLists the actual parameters in the same order as the formalparametersIN OUT ParameterSupplies an input value, which may be returned as a modified valuey
2Try It / Solve It1.Name the three modes for parameters and indicate which mode is the default mode. Which modecannot be modified inside the procedure?
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/respective owners. or its affiliates. Other names may be trademarks of their2. Procedures:A.Create a procedure that receives a country_id as an IN parameter and returns the name andpopulation of that country as OUT parameters. Include an exception handler to trap theNO_DATA_FOUND exception if the country does not exist. The procedure should not displaythe returned values; this will be done in the next step. Name your procedure find_area_pop.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture