Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie question: "is" vs "as"
On Thu, 22 Feb 2007 15:52:55 -1000, sean nakasone wrote:
> What's the difference between "is" and "as" when used at the end of the
> create statement?
>
There is no diffference.
These are aliases for the same thing, created as a courtesy to those who want to 'read' the header as a sentance. For example, try
CREATE PROCEDURE abc AS (vs) CREATE PROCEDURE abc IS
PROCEDURE abc IS (vs) PROCEDURE abc AS
Since they are aliases, you are free to use either as you feel comfortable.
-- Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com) *** Feel free to correct me when I'm wrong! *** Top posting [replies] guarantees I won't respond.Received on Fri Feb 23 2007 - 06:46:22 CST