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 -> Creating a procedure and function HELP

Creating a procedure and function HELP

From: <simon_s_li_at_hotmail.com>
Date: 16 Mar 2006 06:08:44 -0800
Message-ID: <1142518123.996520.323130@u72g2000cwu.googlegroups.com>


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 Received on Thu Mar 16 2006 - 08:08:44 CST

Original text of this message

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