Re: Create type object AS / IS

i think this has historical reasons like the varchar varchar2 thing

Ian Ledzion wrote:

> 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.
  Received on Mon Jul 30 2001 - 14:33:42 CDT