Home » SQL & PL/SQL » SQL & PL/SQL » Diffrence between 'IS' and 'AS' in Procedure creation (Oracle 10g, Windows XP)  () 1 Vote
Diffrence between 'IS' and 'AS' in Procedure creation [message #291074] Wed, 02 January 2008 23:14 Go to next message
cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...
Junior Member

In Procedure creation, what is the usage of 'AS' instead of 'IS':

CREATE [OR REPLACE] PROCEDURE procedure_name
[(parameter1 [mode1] datatype1,
parameter2 [mode2] datatype2,
. . .)]
IS|AS
PL/SQL Block;

Let me know the correct difference.

Thanks and Regards,
Suresh.
Re: Diffrence between 'IS' and 'AS' in Procedure creation [message #291075 is a reply to message #291074] Wed, 02 January 2008 23:17 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Let me know the correct difference.
One contains "I" & the other contains "A"; otherwise there is no difference.
Previous Topic: Query regarding Exchange Partiiton
Next Topic: where to create external table
Goto Forum:
  


Current Time: Fri Dec 02 14:23:21 CST 2016

Total time taken to generate the page: 0.28241 seconds