Re: user defined data type: does they exist ?
Date: Thu, 17 Jan 2008 06:54:17 -0800 (PST)
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
> 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