Re: Create type object AS / IS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 30 Jul 2001 19:20:29 +0200
Message-ID: <996513632.9200.0.pluto.d4ee154e@news.demon.nl>

"Ian Ledzion" <ian.ledzion_at_lgxbow.com> wrote in message news:9k3hjj$9h4$1_at_rex.ip-plus.net...
> I've been trying without success to find the difference (if any) between
the
> statements AS and IS when creating an object type.
>
> For example
> CREATE TYPE typ_person AS /*Here*/ OBJECT (
> id NUMBER (9),
> name VARCHAR2 (30));
> ;
>
> and
>
> CREATE TYPE typ_person IS /*Here*/ OBJECT (
> id NUMBER (9),
> name VARCHAR2 (30));
> ;
>
> Can anyone explain the reason for the two versions?
>
> Thanks,
> Ian.
>
>

Check your sql reference manual and you will see it also applies to procedures and functions.
Why is this so important for you?
I would imagine there are way more important things in Oracle to bother about.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 30 2001 - 12:20:29 CDT