How to create user-defined column types?, not objects.Help, please

From: buz <buzonunNOVALE_at_QUITAESTOwanadoo.es>
Date: Wed, 3 Oct 2001 23:58:46 +0200
Message-ID: <9pg1lr$1in6_at_cesio.mundo-r.com>


I want to create user defined types like

TYPE dom_address AS char(45)

so then I write

CREATE TABLE emp (
id_emp INTEGER,
addr_emp dom_addres);

Note that this does not involves using Object types at all. I think it is very useful for using "alias" for column types that are more explicit and readable, and reutilisable as data type in other columns with the same nature.

Can that be done in Oracle8i?
If the answer is yes, which is the syntax of the statement to do that? Thanks in advance,
Buz. Received on Wed Oct 03 2001 - 23:58:46 CEST

Original text of this message