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

From: Lewis C <lewisc_at_excite.com>
Date: Mon, 09 May 2005 02:41:58 GMT
Message-ID: <eajt719s0bbup1s747d411509bnr01i6pu@4ax.com>

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

---

Lewis R Cunningham

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

---

Received on Sun May 08 2005 - 21:41:58 CDT