What is the difference between "AS" and "IS" in an Oracle stored procedure?
None whatsover. They are synonyms supplied to make your code more readable:
FUNCTION f IS ...
CREATE VIEW v AS SELECT ...
One minor difference...
They are synonyms for packages and procedures, but not for cursors:
This works...
cursor test_cursorisselect * from emp;
... but this doesn't:
cursor test_cursorasselect * from emp;
"IS" and "AS" act as a synonym while creating procedures and packages but not for a cursor, table or view.