Re: design question
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sun, 7 Sep 2008 10:14:56 -0700 (PDT)
Message-ID: <248e8605-5c44-4352-a7a2-a11fbee67ee0@59g2000hsb.googlegroups.com>
Date: Sun, 7 Sep 2008 10:14:56 -0700 (PDT)
Message-ID: <248e8605-5c44-4352-a7a2-a11fbee67ee0@59g2000hsb.googlegroups.com>
On Sep 7, 7:34 am, "Chris Seidel" <csei..._at_arcor.de> wrote:
snip
> OK, one could change A in a way that the values are stored natively:
>
> create table ObjectProperty (ID numeric(10), ObjectID numeric(10), Fieldname
> varchar2(50), FieldvalueV varchar2(4000), FieldvalueN numeric(30,2),
> FieldvalueD date);
You might want to see what Tom and others think of varchar2(4000) ... it ain't pretty.
http://asktom.oracle.com and do a search is one way
Several other recent discussions here on cdos of varchar2(4000) if you use the google interface the newsgroup is pretty searchable. Received on Sun Sep 07 2008 - 12:14:56 CDT