Oracle does not support aliases for datatypes, but in Oracle 8 you could
define a object type e.g. postcode as varchar2.
Regards
David Russell
mkaushik_at_harvestinc.com wrote in message
<6gjiug$a12$1_at_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 Sat Apr 11 1998 - 15:00:39 CDT
