Course Hero Logo

StoredProC. part1.sql - Student ID:2010951 Lab Sheet -...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 3 pages.

Student ID:2010951Lab Sheet - Stored Procedures Part 1Complete the following exercises in PostgreSQL using PL/pgSQL1. Write a function that takes as argument two numbers and returns their sum.
2. Write a function that takes as argument two numbers and calculates their sum.If the sumexceeds 10, an appropriate message is printed, else a different message isprinted.
3. Write a function that takes as argument two numbers, adds the first number toitself untilthe sum reaches the second number. The function prints the final sum.
4. Write a function that takes three arguments, the first two being two integervalues and the

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 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
Addition, Fahrenheit, Celsius

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture