A procedure is created and variables are declared. But I can't understand what this piece of code means? More precisely, what is operator for?

 CREATE OR REPLACE Procedure UpdateCourse ( name_in IN varchar2 ) IS cnumber number; 
  • Instead of IS, you can safely use AS - in this context they are equivalent. - Akina

1 answer 1

 CREATE OR REPLACE Procedure UpdateCourse ( name_in IN varchar2 ) --объявление процедуры IS -- служебное слово, говорящее что дальше будет идти тело процедуры cnumber number; -- объявление переменной внутри процедуры 

That is, the keyword is to separate the parts.