Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can one create a type (domain) and see it in the OEM type dropdown lists?
On 8 May 2005 15:09:45 -0700, "deanbrown3d" <deanbrown3d_at_yahoo.com>
wrote:
>Ok ok OK! I did post an update that said I meant varchar2, not varchar!
>Could someone please answer my OP? I'd appreciate it.
>
>Thanks
>
>Dean
I would agree with Dan to go with the larger value.
If you can't do that, go with the smaller and then add an alter to increase the size for the customer that needs the larger value. You won't lose anything.
Or just maintain 2 install scripts with different DDL. How ugly is that!
But there really is no justifiable reason to not go with the larger varchar2 value.
My 2 cents.
Lewis
Author, ItToolBox Blog: An Expert's Guide to Oracle http://blogs.ittoolbox.com/oracle/guide/
Topic Editor, Suite101.com: Oracle Database http://www.suite101.com/welcome.cfm/oracle
Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752
![]() |
![]() |