Menu
I see Oracle procedures sometimes written with "AS", and sometimes with "IS" keyword.
CREATE OR REPLACE Procedure TESTUSER.KILLINSTANCE (INSTANCEID integer) **AS** ... vs.
CREATE OR REPLACE Procedure TESTUSER.KILLINSTANCE (INSTANCEID integer) **IS** ... Is there any difference between the two?
746
They are equivalent. Just different way of writing. Use what you like better. The difference is that way back in the day, there was one developer in one building on the Oracle campus that started using "is".
Question: What is the difference between 'IS' and 'AS' in PL/SQL? Answer: The PL/SQL language evolved such the the "IS" and "AS" operators are equivalent. Functionally the "IS" and "AS" syntax performs identical functions and can be used interchangeably.
Creating a simple stored procedure The AS keyword separates the heading and the body of the stored procedure. If the stored procedure has one statement, the BEGIN and END keywords surrounding the statement are optional. However, it is a good practice to include them to make the code clear.
The procedure body begins with the keyword IS (or AS ) and ends with the keyword END followed by an optional procedure name. The procedure body has three parts: an optional declarative part, an executable part, and an optional exception-handling part.
None whatsover. They are synonyms supplied to make your code more readable:
FUNCTION f IS ...
CREATE VIEW v AS SELECT ...
163
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
