Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating a procedure and function HELP

Re: Creating a procedure and function HELP

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 18 Mar 2006 07:54:14 -0800
Message-ID: <1142697229.696162@yasure.drizzle.com>


gazzag wrote:

> simon_s_li_at_hotmail.com wrote:

>> Hi,
>>
>> Can anyone tell me what the difference with the keyword 'IS' and 'AS'
>> when used after the declaration of the procedure of function.
>>
>> Example:
>>
>> CREATE OR REPLACE FUNCTION(val VARCHAR) RETURN VARCHAR2 IS
>>
>> CREATE OR REPLACE FUNCTION(val VARCHAR) RETURN VARCHAR2 AS
>>
>> When do you use 'IS' and when do you use 'AS'????
>>
>> Regards
>> Simon
> 
> 'IS' when what follows is PL/SQL, 'AS' when to map a Java or C method
> name.
> 
> HTH
> 
> -g

There is NO difference between AS and IS. Choose either one and stick with it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Mar 18 2006 - 09:54:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US