Re: What is a UDT?

Hans Forbrich wrote:

> 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).

Follow-up question. What report writers have you found that supported nested tables based on collections and objects?

Seagate? Brio? Cognos? etc.? Does anyone have experience with this?

Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)