Re: Help, my developers are killing me with varchar2(4000)
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 13 Aug 2008 22:37:29 +1000
Message-ID: <g7uki9$g6p$3@registered.motzarella.org>
Date: Wed, 13 Aug 2008 22:37:29 +1000
Message-ID: <g7uki9$g6p$3@registered.motzarella.org>
gazzag wrote,on my timestamp of 13/08/2008 10:09 PM:
> I agree with all the comments regarding "bit-buckets". However, has
> anyone noticed that, when using Oracle XE's Object Browser to create a
> table - I don't use GUI's to create objects as I prefer to script them
> but I was demonstrating the GUI to a developer, ironically - when you
> create a column of type VARCHAR2 the scale defaults to a value of
> 4000?
What does NUMBER default to? (Sorry, haven't touched XE in years!)
>
> Oracle's not even giving us DBA's a fighting chance to stamp out bad
> habits! :)
That's more a habit than many would admit... ;) Received on Wed Aug 13 2008 - 07:37:29 CDT