Question: Based on the in class examples from Flat file function proc example.sql 1 . Create and test a Function named ( f _ {

Based on the in class examples from Flat file function proc example.sql
1. Create and test a Function named \( f_{-}\)add20 that accepts one integer parameter. The function then adds 20 and returns the result as an Integer.
This should work against your function: select f_add20(3) from dual;
2. Create and test a Procedure named \( p_{-}\)add2Numbers that accepts two integers as parameters. The Procedure should then add the integers together and return an integer result.
The following should work against your Procedure:
call p_add2Numbers (1,3,@mySum);
select @mySum;
Based on the in class examples from Flat file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!