Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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