Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!p01!news2.east.cox.net.POSTED!53ab2750!not-for-mail
From: "Ryan" <rgaffuri@cox.net>
Newsgroups: comp.databases.oracle.server
References: <3F085794.64CF69C@exxesolutions.com> <0u4Oa.9416$ZT5.4182@news2.east.cox.net> <3F09D99E.E094AF33@exxesolutions.com>
Subject: Re: What is a UDT?
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <QClOa.11832$ZT5.9114@news2.east.cox.net>
Date: Mon, 07 Jul 2003 21:29:20 GMT
NNTP-Posting-Host: 68.100.139.158
X-Complaints-To: abuse@cox.net
X-Trace: news2.east.cox.net 1057613360 68.100.139.158 (Mon, 07 Jul 2003 17:29:20 EDT)
NNTP-Posting-Date: Mon, 07 Jul 2003 17:29:20 EDT
Organization: Cox Communications
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237097


"Daniel Morgan" <damorgan@exxesolutions.com> wrote in message
news:3F09D99E.E094AF33@exxesolutions.com...
> Ryan wrote:
>
> > "Daniel Morgan" <damorgan@exxesolutions.com> wrote in message
> > news:3F085794.64CF69C@exxesolutions.com...
> > > Oracle 9.2.0.2.0 on Win2K
> > >
> > <snipped>
> >
> >
> > 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)
>
>

i use pl/sql tables and ref cursors alot. havent really worked with XML yet.
Im familiar with it, just havent been on a project with a need for it.

never occurred to me that you would use object types with xml. Ill have to
look into it.