Re: domains aren't subtypes, right?

From: Alfredo Novoa <alfredo_at_ncs.es>
Date: 26 May 2003 05:10:21 -0700
Message-ID: <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.

Regards
Alfredo Received on Mon May 26 2003 - 14:10:21 CEST

This message: [ Message body ]
Next message: Kenneth Downs: "Re: Database Builders, Code Generators, On-Topic?"
Previous message: Alfredo Novoa: "Re: domains aren't subtypes, right?"
Maybe in reply to: Marshall Spight: "domains aren't subtypes, right?"
In reply to Mikito Harakiri: "Re: domains aren't subtypes, right?"
Next in thread: Kenneth Downs: "Re: Database Builders, Code Generators, On-Topic?"
Reply: Alfredo Novoa: "Re: domains aren't subtypes, right?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message