Question

Write a PL/SQL procedure called FENCE that takes three arguments MIN, MAX, STEP and

sends to the screen the numbers:

MIN, MIN+STEP, MIN+2*STEP, etc. up to MAX.

Note: the last number before MAX could be closer to MAX than STEP.

Every number should be shown in a separate row.

MAX should be shown. This should work for negative numbers too.

Example:

FENCE(2, 9, 3)

Should send to the screen:

2

5

8

9

Write a main program that calls FENCE(…) one time.

Show the complete PL/SQL code.

Both procedure and main program.

Show a SNIP of SQL Developer that shows

================================

Write a PL/SQL function FENCESUM that takes three arguments MIN, MAX, STEP and that

computes and returns the SUM of all the FENCE values.

Example:

FENCESUM(2, 9, 3)

Should return

24

FENCESUM should be called by a main program that sends the result of FENCESUM to the

screen.

Show the complete PL/SQL code. Both function and main program.

Answer 1

1. PL/SQL PROCEDURE:

DECLARE
MINN number;
MAXX number;
STEP number;

PROCEDURE FENCE(MINN IN number, MAXX IN number, STEP IN number) IS
BEGIN
dbms_output.put_line(MINN);
dbms_output.put_line(MINN+STEP);
dbms_output.put_line(MINN+2*STEP);
dbms_output.put_line(MAXX);
END;



BEGIN
MINN:= 2;
MAXX:= 9;
STEP:= 3;
FENCE(MINN, MAXX, STEP);
END;
/

SCREENSHOT:

OUTPUT:

2. PL/SQL FUNCTION:

DECLARE
MINN number;
MAXX number;
STEP number;
SUMM number;

FUNCTION FENCESUM(MINN IN number, MAXX IN number, STEP IN number)
RETURN NUMBER
IS
BEGIN
RETURN (MINN+MAXX+STEP);
END;



BEGIN
MINN:= 2;
MAXX:= 9;
STEP:= 3;
SUMM:=FENCESUM(MINN, MAXX, STEP);

dbms_output.put_line(SUMM);
END;
/

SCREENSHOT: