Question: Write the PL/SQL code to create a procedure with only one IN parameter. Name the procedure as follows: -- The first 2 letters of

Write the PL/SQL code to create a procedure with only one IN parameter. Name the procedure as follows: -- The first 2 letters of the procedure name will have your INITIALS (in my case is NC) -- the rest of the procedure name should be a sensible and meaningful name. The procedure will accept a mark value and decrease it by 5% if that mark is between 90 and 100, then by 10% if that mark is greater than 70 and less than 90, then increase it by 10% if that mark is between 50 and 60, otherwise will be NO change. Then the new mark will be printed on the screen. Put the code that will print a Warning if the input mark is NOT between 0 and 100. For example, if your input was 80, then new mark should show 72 and If your input was 65, then new mark should show the same value. Finally, if your input was 101, you should see "Warning. Your mark is out of range." Show how you test your Procedure with 3 different marks. (4 marks)
Step by Step Solution
There are 3 Steps involved in it
Heres the PLSQL code for the described procedure To test ... View full answer
Get step-by-step solutions from verified subject matter experts
