Re: Can one create a type (domain) and see it in the OEM type dropdown lists?

deanbrown3d wrote:

> Hi there,
>
> We want to create a field F of type varchar(6) for use in one client's
> version of our software, and then the same field F of type varchar(12)
> for use in another. What's the best way to go about doing this. Neither
> company want to use the alternate size field definition.
>
> Is there a way to define a type (MyVar say) as something that we can
> change, and then see it in the type field for use in tables? And if so,
> once this is done, can we change it at will, assuming there is no data
> loss or such issues?
>
> Thanks for any advice,
>
> Dean

Use VARCHAR2(12). There is no valid reason for anyone to want to use VARCHAR2(6) in preference to (12) if you are the vendor. And in Oracle NEVER use VARCHAR unless you are writing C.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)