Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: rgaffuri@cox.net (Ryan Gaffuri) Newsgroups: comp.databases.oracle.server Subject: Re: What is a UDT? Date: 7 Jul 2003 03:38:37 -0700 Organization: http://groups.google.com/ Lines: 29 Message-ID: <1efdad5b.0307070238.462b56ab@posting.google.com> References: <3F085794.64CF69C@exxesolutions.com> <0u4Oa.9416$ZT5.4182@news2.east.cox.net> <3F08D6F0.1D1D12F0@telusplanet.net> NNTP-Posting-Host: 198.80.171.28 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1057574318 17823 127.0.0.1 (7 Jul 2003 10:38:38 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 7 Jul 2003 10:38:38 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237045 Hans Forbrich 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 > > Huge potential savings in maintenance cost alone - usually enough to be able to > afford the increase in processor size (and then some). that makes sense. didnt occur to me. I just use varchars for addresses. however, having an object for an address could work. thanks.