How to create an alias to a subtype?
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
