Re: Creating functions: IS vs AS
From: Laurenz Albe <invite_at_spam.to.invalid>
Date: Thu, 4 Jun 2009 16:25:56 +0200
Message-ID: <1244125578.216974_at_proxy.dienste.wien.at>
Á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.
Date: Thu, 4 Jun 2009 16:25:56 +0200
Message-ID: <1244125578.216974_at_proxy.dienste.wien.at>
Á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?
Yours,
Laurenz Albe
Received on Thu Jun 04 2009 - 09:25:56 CDT