Re: User-Defined (custom) Data Types on Oracle

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/03/24
Message-ID: <33366261.5BA@pmcgettigan.demon.co.uk>#1/1

NNOOR wrote:
>
> What is the way to have user-defined data types on an Oracle DB? We want
> to give our names to some data types and, if possible, contraints that
> will work on that type. These "new" types will be used in column
> definitions so that any future changes hav eto be done only at one place.
>
> Thanks for your help!!!
>
> Regards,
> Nasir (nnoor_at_cris.com)

AFAIK, you'll need Oracle 8 for this facility. I have seen user defined types demo'd on Oracle 8, but as for any prior release - unlikely.

Steve Phelan. Received on Mon Mar 24 1997 - 00:00:00 CST