User-Defined Datatype...
From: Chris Chi <stvllium_at_ms18.hinet.net>
Date: Mon, 5 Mar 2001 11:52:11 +0800
Message-ID: <97v44e$97f_at_netnews.hinet.net>
Date: Mon, 5 Mar 2001 11:52:11 +0800
Message-ID: <97v44e$97f_at_netnews.hinet.net>
Hi All
How can I define a "DOMAIN" datatype, code as below :
CREATE TABLE T1
NOColumn1 VARCHAR2(10) <- define a varchar2 column, and size is 10
);
CREATE TABLE T2
NOColumn2 VARCHAR2(10) <- define a varchar2 column, and size is 10
);
how can I define "VARCHAR2(10)" as NoType user-defined datatype :
CREATE TABLE T1
NOColumn1 NoType <- define a "NoType" column, and size is referenced to
NoType
);
CREATE TABLE T2
NOColumn2 NoType <- define a "NoType" column, and size is referenced to
NoType
);
Thanks
Chris Chi Received on Mon Mar 05 2001 - 04:52:11 CET