Pl/sql

[jenni]

what is the difference of IS/AS in procedure and function in PL/SQL?
when IS is used and When AS is used?

[amitpatel66]

what is the difference of IS/AS in procedure and function in PL/SQL?
when IS is used and When AS is used?

Both are the same. There is no difference. But I use it my way:

For eg:

[code=oracle]

CREATE OR REPLACE PROCEDURE abc AS.......

CREATE OR REPLACE PACKAGE BODY abs AS
PROCEDURE abc1 IS.....

[/code]

When I use CREATE keyword I use "AS" and in other case I use "IS" just that it sounds good...but you can use either of them any where..no hard and fast rules as such!!

[debasisdas]

There is nod ifference at all. You can use either of the two .

[nileshpardeshid]

difference between is and as is not much but there functionality is difference.