如何在oracle pl SQL中找到sum [英] How to find sum in oracle pl SQL

问题描述

我在pl sql中查找平均代码但是收到错误。

下面我给出了错误的代码。

Hi,
I am doing a find average code in pl sql but getting error.
Below i am giving tried code with error.

DECLARE
   type namearray IS VARRAY(5) OF VARCHAR2(10);
   type grade IS VARRAY(5) OF INTEGER;
   names namearray;
   marks grade;
   total integer;
   sum integer := 0;
BEGIN
   names := namearray('Kavita', 'Pritam', 'Ayan', 'Rishav', 'Aziz');
   marks := grade(98, 97, 78, 87, 92);
   total := names.count;
   dbms_output.put_line('Total '|| total || ' Students');
   FOR i in 1 .. total LOOP
sum:= sum + marks(i);
dbms_output.put_line(marks(i));
  END LOOP;
dbms_output.put_line(sum / total);
END;

错误

------------ ---------

Error
---------------------

ORA-06550: line 14, column 11:
PLS-00103: Encountered the symbol "+" when expecting one of the following:

   (
The symbol "(" was substituted for "+" to continue.
ORA-06550: line 14, column 21:
PLS-00103: Encountered the symbol ";" when expecting one of the following:

   . ( ) * % & - + / at mod remainder rem  ||
The symbol ")" was substituted for ";" to continue.
ORA-06550: line 17, column 26:
PLS-00103: Encountered the symbol "/" when expecting one of the following:

   (

我尝试过： < br $> b $ b

................................... .................................................. ..............

What I have tried:

...................................................................................................

推荐答案

问题是总和是保留字（参见 Summation - Wikipedia [ ^ ]）。



尝试更改变量名称。例如 mysum ：

The problem is that sum is a reserved word (see Summation - Wikipedia[^]).

Try to change the variable name. For example mysum:

DECLARE
   type namearray IS VARRAY(5) OF VARCHAR2(10);
   type grade IS VARRAY(5) OF INTEGER;
   names namearray;
   marks grade;
   total integer;
   mysum integer := 0;
BEGIN
   names := namearray('Kavita', 'Pritam', 'Ayan', 'Rishav', 'Aziz');
   marks := grade(98, 97, 78, 87, 92);
   total := names.count;
   dbms_output.put_line('Total '|| total || ' Students');
   FOR i in 1 .. total LOOP
      mysum := mysum + marks(i);
      dbms_output.put_line(marks(i));
  END LOOP;
dbms_output.put_line(mysum / total);
END;
/

这篇关于如何在oracle pl SQL中找到sum的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！