Re: user defined data type: does they exist ?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 17 Jan 2008 06:54:17 -0800 (PST)
Message-ID: <edc71c7e-8a59-4b19-97b8-38a18fc6cf9c@i3g2000hsf.googlegroups.com>


On Jan 17, 9:20 am, alberto.rol..._at_gmail.com wrote:
> I'm migrating an application from sql server to oracle.
>
> We have tables with column that use user defined data type, for
> example
>
> CREATE TABLE AA (
>     Column1  CODE
> )
>
> Where CODE is defined as varchar(50)
>
> Is there a way to create an equivalent CODE in oracle ?

Yes, Oracle had this feature since version 8.0.

Read the following:
Oracle version# Application Developers Guide - Fundamentals Application Developers Guide - Object-Relational Features SQL Manual entry CREATE TYPE
PL/SQL User's Guide and Reference -- contains many examples of using object types

HTH -- Mark D Powell -- Received on Thu Jan 17 2008 - 08:54:17 CST

Original text of this message