Re: What is a UDT?

Hans Forbrich <forbrich_at_telusplanet.net> wrote in message news:<3F08D6F0.1D1D12F0_at_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. Received on Mon Jul 07 2003 - 05:38:37 CDT