Question: what is the difference between is and as in oracle function and procedure?
Answer: "IS" and "AS" act as a synonym while creating procedures and packages but not for a cursor, table or view. The AS keyword is used instead of the IS keyword for creating a standalone procedure. IS is for embedded (within a block, subprogram or package) entities.