Re: Disadvantages of the implementation of explicit subtypes on MS SQL 7 and Oracle8i/9i

Janusz Jezowicz wrote:

> DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E189FB8.8EB1851E_at_exesolutions.com>...
> > Janusz Jezowicz wrote:
> >
> > > Could some database expert post some information or link about that?
> > >
> > > thanks
> > >
> > > Janusz
> >
> > With respect to Oracle 8i and 9i. To what, exactly, are you referring?
> >
> > Your question is loaded with ambiguity, or perhaps, T-SQL which may have
> > a very different or no meaning in the context of Oracle.
> >
> > Daniel Morgan
>
> Sorry that I didn`t make it clear. I am no expert in Oracle or MS SQL,
> but I thought that there are some options how to create user defined
> types and their subtypes. If someone could make some comparison or
> list of possibilities how to implement following behaviour?
>
> Janusz

I know nothing of SQL Server (it isn't MS SQL ... there is no such thing) so I'll address Oracle.

There is no disadvantage in creating user defined types of which I am aware and I do so frequently. What makes you think there is, or should be one?

If I were to really stretch for a disadvantage the only one I could come up with would be that novices might not understand what they are looking at and get confused.

Daniel Morgan Received on Mon Jan 06 2003 - 11:12:17 CST