How to create an alias to a subtype?

From: Jose P. <colletodo_at_hotmail.com>
Date: 10 Oct 2001 07:23:13 -0700
Message-ID: <27f05816.0110100623.59125386_at_posting.google.com>


Hi,
 How can I create an alias to a subtype?

 I.e. How can I asscciate a name with a subtype?

 Associate DOM_ADDRES with the type CHAR(50) or  associate DOM_TELNO with the type NUMBER(10,0)

 so I can use it in the creation of a table like  CREATE TABLE T1 (id INTEGER, addr DOM_ADDRES , tel DOM_TELNO);

 I tried CREATE DOMAIN statement -> Not working, statement not  exists.
 I tried SUBTYPE lll IS CHAR(3) but it only works in PL/SQL  programming, I can't create tables with that.

 Is it possible? Am I doing something wrong?  I think subtyping and aliasing is very useful for readability and  reuse.
 I don't want to use CREATE TYPE AS OBJECT, I do not need objects  in my DB.
 I am using Oracle 8.1.7 for Linux.

 TIA,
 Jose P. Received on Wed Oct 10 2001 - 16:23:13 CEST

Original text of this message