Here two variables are declared. Here I can not understand this. Before IS and after IS is announced.

CREATE OR REPLACE Function FindCourse ( name_in IN varchar2 ) RETURN number IS cnumber number;
  • 2
    name_in IN varchar2 - the input variable in the FindCourse function. RETURN number - the type of the returned data. cnumber number local function variable - Okdel
  • Body function is not enough - aleks.andr February
  • Question to the "local". My comment to issue as an answer. Or the question does not quite match the subject of the site? - Okdel
  • one
    And what is the mysql tag doing here? he just pribaldeet from such a design ... - Akina

1 answer 1

 CREATE OR REPLACE Function FindCourse ( name_in IN varchar2 ) /* входящая переменная в функцию FindCourse*/ RETURN number /* тип возвращаемых данных*/ IS cnumber number; /* локальная переменная функции*/