IS and AS

#1

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

Quote:

| ' has bad check digit');
END IF;

END;
....

#2

"O_TEXT" <O_TEXT (AT) nospam (DOT) fr> a écrit dans le message de news: gkfpg2$1187$1 (AT) biggoron (DOT) nerim.net...

Quote:

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

#3

O_TEXT schreef:

Quote:

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;
...

It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.

#4

Shakespeare a écrit :

Quote:

O_TEXT schreef:
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;
...

It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.

Is it possible to know on which rule PLSQL is based for parsing?

#5

O_TEXT schreef:

Quote:

Shakespeare a écrit :
O_TEXT schreef:
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;
...
It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.

Is it possible to know on which rule PLSQL is based for parsing?

You could check out the syntax diagrams in the docs.

Shakespeare

#6

Shakespeare a écrit :

Quote:

O_TEXT schreef:
Shakespeare a écrit :
O_TEXT schreef:
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;
...
It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.

Is it possible to know on which rule PLSQL is based for parsing?

You could check out the syntax diagrams in the docs.

Shakespeare

such as

http://download.oracle.com/docs/cd/A...6/13_elems.htm

#7

O_TEXT schreef:

Quote:

Shakespeare a écrit :
O_TEXT schreef:
Shakespeare a écrit :
O_TEXT schreef:
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;
...
It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.
Is it possible to know on which rule PLSQL is based for parsing?

You could check out the syntax diagrams in the docs.

Shakespeare

such as

http://download.oracle.com/docs/cd/A...6/13_elems.htm

Such is indeed

Shakespeare

#8

O_TEXT schreef:

Quote:

Shakespeare a écrit :
O_TEXT schreef:
Shakespeare a écrit :
O_TEXT schreef:
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;
...
It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.
Is it possible to know on which rule PLSQL is based for parsing?

You could check out the syntax diagrams in the docs.

Shakespeare

such as

http://download.oracle.com/docs/cd/A...6/13_elems.htm

I must admit, constructor functions are not part of the diagrams...
but the parser must be treating a constructor function different than a
'normal' function, knowing it should end with returning .. as result.

Shakespeare

#9

O_TEXT wrote:

Quote:

Shakespeare a écrit :
O_TEXT schreef:
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;
...
It's all a matter of parsing....

Shakespeare

BTW: in many cases, AS and IS are interchangeable.

Is it possible to know on which rule PLSQL is based for parsing?

http://download.oracle.com/docs/cd/A...82.htm#2064465

as|is clause, meaning it is interchangeable.
Works for all SQL create statements, afaik.

--

Regards,
Frank van Bortel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

IS and AS

comp.databases.oracle.tools comp.databases.oracle.tools

IS and AS - 01-12-2009 , 10:01 AM

Re: IS and AS - 01-12-2009 , 10:08 AM

Re: IS and AS - 01-12-2009 , 10:19 AM

Re: IS and AS - 01-12-2009 , 11:04 AM

Re: IS and AS - 01-12-2009 , 12:15 PM

Re: IS and AS - 01-13-2009 , 02:53 AM

Re: IS and AS - 01-13-2009 , 05:12 AM

Re: IS and AS - 01-13-2009 , 05:30 AM

Re: IS and AS - 01-22-2009 , 04:13 AM