Home » SQL & PL/SQL » SQL & PL/SQL » Procedure Syntax
Procedure Syntax [message #201175] Thu, 02 November 2006 21:05 Go to next message
vp17in
Messages: 12
Registered: November 2006
Junior Member
Procedure declaring

create or replace procedure <<procedure name>> (Argument List) AS (or)IS

My questions

1. Is the keywords "create or replace" mandatory while declaring a procedure (or) we can just start as

procedure <<procedure name>> (Argument List) AS (or)IS

2. What is "AS (or)IS" that comes at the last of the declaration. What do they mean?
Re: Procedure Syntax [message #201188 is a reply to message #201175] Thu, 02 November 2006 23:04 Go to previous messageGo to next message
fakhar55
Messages: 99
Registered: September 2005
Location: UAE
Member
Your question sounds like asking someone that
"What is your name"?
"Ok if this is your name why it John not David?"
Each language has it's standards to be followed in written and spoken by all it's users worldwide. Same apply for computer languages whether programming/scripting or query languages.
The syntax should be followed as it is standardized to be understood by all the potential users plus the programming language itself.So in PL/SQL the syntax of procedure is as u described and you should follow that.
Hope it is clear now.
Re: Procedure Syntax [message #201194 is a reply to message #201175] Thu, 02 November 2006 23:57 Go to previous messageGo to next message
vp17in
Messages: 12
Registered: November 2006
Junior Member
Sorry. You didn't answer my question.

Whether create (or) Replace is mandatory. Tell me that.

There is "IS" and "AS". When to use what. Why there are 2 things(AS and IS)

POLITE - Hope u know the meaning of this word.
Re: Procedure Syntax [message #201195 is a reply to message #201194] Fri, 03 November 2006 00:05 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
RTFM

hope you know the meaning of that

Fakhar55 did answer your question.
Re: Procedure Syntax [message #201212 is a reply to message #201194] Fri, 03 November 2006 01:52 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/1681/0/ Why wouldn't you check it yourself? Oracle provides documentation about (almost) everything; here is what they say about CREATE PROCEDURE statement.

Shortly:
  • yes, CREATE is obligatory (REPLACE is not)
  • IS and AS are the same; no difference (except the first letter)
Previous Topic: Split comma separated string (Merged)
Next Topic: would like to double check .....
Goto Forum:
  


Current Time: Thu Dec 08 14:36:57 CST 2016

Total time taken to generate the page: 0.26857 seconds