Datatypes related

From: <mkaushik_at_harvestinc.com>
Date: Thu, 09 Apr 1998 17:43:28 -0600
Message-ID: <6gjiug$a12$1@nnrp1.dejanews.com>

User defined types in Oracle refer to composite fields. In Sybase they are more like typedefs in C/C++ e.g I would define a user defined type ut_zip as char(6) This way whenever I had to store addresses the zip field would be of type ut_zip.

This facilitated a single point of change to all zip fields and also maintenance / searching the database for zip fields.

How can I achieve the same in Oracle ?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 09 1998 - 18:43:28 CDT