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:
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
--
- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
- Mi sitio sobre programación web: http://borrame.com
- Mi web de humor satinado: http://www.demogracia.com --