What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS?

Interview Candidate
Apr 14th, 2006
13
6436

Showing Answers 1 - 13 of 13 Answers

prafull.vn
Profile Answers by prafull.vn Questions by prafull.vn

Apr 18th, 2006

both are equivalent .. Just replacement of DECLARE keyword in declarative section.

gopikumar
Profile Answers by gopikumar

Sep 17th, 2007

There is no difference between "IS" and "AS" in Procedures........
We can use any of them while creating a procedure.

sampra
Profile Answers by sampra

Mar 10th, 2008

both are same

praveengowda
Profile Answers by praveengowda

May 23rd, 2008

There is no difference as such,
We use AS when Stored Procedure is defined in a package if SP is outside pkg we use IS. Here is the example

Ex: AS
Pakcage Header
create package schema.testpkg as

....
procedure sp_test(....);

end testpkg;

create package body schema.testpkg
is

procedure sp_test(..)
AS
....
end sp_test;

end testpkg;

Ex: IS

create schema.test_sp(....)
IS
..
BEGIN
..
END test_sp;