Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Create type object AS / IS

Create type object AS / IS

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Mon, 30 Jul 2001 13:48:48 +0200
Message-ID: <9k3hjj$9h4$1@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. Received on Mon Jul 30 2001 - 06:48:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US