Creating functions: IS vs AS

From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Thu, 04 Jun 2009 13:02:02 +0200
Message-ID: <h089jn$dec$1_at_news.eternal-september.org>



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.

[1]
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_5009.htm#sthref4707

--

Received on Thu Jun 04 2009 - 06:02:02 CDT

Original text of this message