oracle - PL/SQL 函数中的错误 PLS-00103

Question

此代码不会编译。我不知道发生了什么事。我正在使用 Oracle 8i

CREATE OR REPLACE FUNCTION SALMINS 
IS RETURN NUMBER
   SAL NUMBER(10);
BEGIN
 SELECT MIN(SALARIO) INTO SAL FROM EMPLE;
 RETURN (SAL);
END;

错误：

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1      PLS-00103: Encountered the symbol "IS" when expecting one of the
         following:
         ( return compress compiled wrapped

表定义：

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMP_NO                                    NOT NULL NUMBER(4)
 APELLIDO                                           VARCHAR2(10)
 OFICIO                                             VARCHAR2(10)
 DIR                                                NUMBER(4)
 FECHA_ALT                                          DATE
 SALARIO                                            NUMBER(10)
 COMISION                                           NUMBER(10)
 DEPT_NO                                            NUMBER(2)

标签： oracleplsql

Answer 1

CREATE OR REPLACE FUNCTION SALMINS 
RETURN NUMBER IS   -- and not IS RETURN NUMBER
   SAL NUMBER(10);
BEGIN
 SELECT MIN(SALARIO) INTO SAL FROM EMPLE;
 RETURN (SAL);
END;