Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!news.stupi.se!news.stupi.se!news.tele.dk!news.tele.dk!small.news.tele.dk!npeer.de.kpn-eurorings.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!lnewspeer00.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Newsgroups: comp.databases.oracle.server
References: <3F085794.64CF69C@exxesolutions.com> <0u4Oa.9416$ZT5.4182@news2.east.cox.net> <3F08D6F0.1D1D12F0@telusplanet.net>
Subject: Re: What is a UDT?
Date: Mon, 7 Jul 2003 13:22:19 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 46
Message-ID: <3f0965fc$0$18497$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: host9.audit-commission.gov.uk
X-Trace: 1057580540 reading.news.pipex.net 18497 193.128.236.219
X-Complaints-To: abuse@uk.uu.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237049

"Hans Forbrich" <forbrich@telusplanet.net> wrote in message
news:3F08D6F0.1D1D12F0@telusplanet.net...
> Ryan wrote:
>
> > looks like they snagged UDT from object oriented terminology. Where you
have
> > your primitive data types such as ints, chars, etc... everything else is
> > created by the user. then everything which is created by the programmer.
> >
> > however, considering that most oracle people dont have Object oriented
> > backgrounds, you would think they would beef up the documentation. Now I
> > remember skimming the Object Type docs, and I think I remember a
reference
> > to the term User defined data type, but they really should put 'UDT'
> > somewhere in the documentation to make it easier.
> >
> > btw, has anyone found the Oracle Object types(other than the arrays and
REF
> >
>
> Biggest silliness I see with  developers - reinventing data types - can be
> remedied with  UDTs ...
>
> Q: how many variants of 'Address' definition can a company have?
> A: at least (# of programmers + 3) - assuming no 3rd pty vendors

Q: How many UNIQUE identifiers can any single entity have within an
organization.
A: Number of systems which use the entity + N where N is number of design
boards responsible for each application.

I think this occurs because

a) each board must consider its app the 'master' for the organisation and
therefore comes up with an entity id scheme, which sadly doesn't meet the
primary key requirements of the actual app and so goes in a user defined
field. If the board is responsible for 2 apps then they will choose a scheme
that doesn't fit with either app.


-- 
Niall Litchfield
Oracle DBA
Audit Commission UK