User-Defined Datatype...

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 Sun Mar 04 2001 - 21:52:11 CST