Re: domains aren't subtypes, right?
Date: Tue, 27 May 2003 09:38:50 -0700
Message-ID: <2DMAa.8$GR2.35_at_news.oracle.com>
"Alfredo Novoa" <alfredo_at_ncs.es> wrote in message
news:e4330f45.0305260410.58ec2488_at_posting.google.com...
> "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
news:<qJuza.8$Kj7.111_at_news.oracle.com>...
>
> > Well, if I want to be pragmatic, I define city as VARCHAR2 column in the
> > database. No user defined types.
>
> The Oracle VARCHAR2() construction is a type generator.
>
> The type which VARCHAR2(10) generates is a subtype of the type which
> VARCHAR2(20) generates.
>
> All the types generated by the VARCHAR2(?) construction are subtypes
> of a string type.
That is just lame excuse for unability to develop arbitrary length String datatype. They have VARCHAR2 for stings that are less than 4000 chars, VARCHAR2 in PL/SQL limited to 32K, and finally CLOBs. Those are not subtypes, they are gisgusting implementation artifacts. Hello, it's 21st century, nobody programs cobol anymore! Received on Tue May 27 2003 - 18:38:50 CEST