Re: IS and AS

"O_TEXT" <O_TEXT_at_nospam.fr> a écrit dans le message de news: gkfpg2$1187$1_at_biggoron.nerim.net...
|I was wondering what is the difference between IS and AS, in general
| PL/SQL code.
|
|
| For instance of FUNCTION book_t, how can oracle know if keyword ending
| the header is IS or AS;
| I mean if header returns SELF and declare result variable before BEGIN,
| or if header returns SELF AS RESULT and declare nothing before BEGIN.
|
|
| CREATE OR REPLACE TYPE BODY book_t
| AS
| CONSTRUCTOR FUNCTION book_t (id IN INTEGER,
| title IN VARCHAR2,
| isbn IN VARCHAR2,
| pages IN INTEGER)
| RETURN SELF AS RESULT
| IS
| BEGIN
| SELF.id := id;
| SELF.title := title;
| SELF.isbn := isbn;
| SELF.pages := pages;
| IF isbn IS NULL OR SELF.ck_digit_okay
| THEN
| RETURN;
| ELSE
| RAISE_APPLICATION_ERROR(-20000, 'ISBN ' || isbn
| || ' has bad check digit');
| END IF;
| END;
| ...

one contains I and the other one A.

Regards
Michel Received on Mon Jan 12 2009 - 17:08:35 CET