Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: What is a UDT? Date: Mon, 07 Jul 2003 13:35:42 -0700 Organization: EXE Message-ID: <3F09D99E.E094AF33@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <3F085794.64CF69C@exxesolutions.com> <0u4Oa.9416$ZT5.4182@news2.east.cox.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 40 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237088 Ryan wrote: > "Daniel Morgan" wrote in message > news:3F085794.64CF69C@exxesolutions.com... > > Oracle 9.2.0.2.0 on Win2K > > > > > > 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 > cursors) useful at all? I can see nested tables being useful in a > datawarehouse environment where you want to denormalize for speed... > > but I cant see any reason to use Object Types in the database. why mix a > relational design and an object oriented design? Id think it would be harder > to maintain. > > anyone have a good use for them? I use Types routinely, Object Types not so much, and mostly to support bulk binding and FORALL in place of cursor loops. But I am seeing more and more need for them with XML. -- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)