Re: Creating functions: IS vs AS

From: Laurenz Albe <>
Date: Thu, 4 Jun 2009 16:25:56 +0200
Message-ID: <>

Álvaro G. Vicario wrote:
> I'm writing my first Oracle function (following the CREATE FUNCTION reference [1]) but I can't figure out what's the difference
> between IS and AS. This is what manual has to say about it:
> IS | AS Clause
> Use the appropriate part of this clause to declare the body of the function.
> Any clue about what's appropriate? All I know is that IS works for me and AS doesn't, but I'd like to know their purpose.
> I'm running Oracle 10g XE.

IS and AS should be synonymous; it shouldn't matter which one you use.

What is the statement you use for defining the function, and what error message do you get?

Laurenz Albe Received on Thu Jun 04 2009 - 09:25:56 CDT

Original text of this message