Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: domains aren't subtypes, right?

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@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 - 07:10:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US