The create or replace procedure sp_calcsum1 number (n)
As
N number;
Result1 number;
The begin
N:=0; Result1:=0;
While n<=100 loop
Result1: result1=+ n.
N:=n + 1;
end loop;
DBMS_OUTPUT. PUT_LINE (' the result is' | | result1);
end;

CodePudding user response:

The create or replace procedure sp_calcsum1 ( n
number)As
n number;

The two name repeated, you can change a,

CodePudding user response:

Input parameters and process in the body of the independent variables to repeat, do not know which references