I have been trying to find out what the difference is between the IS
and AS
keywords in PL/SQL when creating an Oracle function or procedure.
I have searched and have been unable to find any information on this. Does anyone know the difference?
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.
There is no difference between is/as ... is is used for creating a new procedure with a new name where as 'as' is used to create a new procedure with existing procedure name... it will not display "procedure already exists".
The procedure body begins with the keyword IS (or AS ) and ends with the keyword END followed by an optional procedure name.
No. This is clearly stated in the MSDN documentation: Procedure names must comply with the rules for identifiers and must be unique within the schema.
I've never known there to be a difference. The Oracle documentation implies that they are synonyms:
The function body begins with the keyword
IS
(orAS
) and ends with the keyword END followed by an optional function name.
Same as DISTINCT and UNIQUE in select statements. i.e, there is no material difference between 'IS' and 'AS'. Backwards compatibility and meeting standards
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