Re: design question

From: hpuxrac <>
Date: Sun, 7 Sep 2008 10:14:56 -0700 (PDT)
Message-ID: <>

On Sep 7, 7:34 am, "Chris Seidel" <> wrote:


> 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. 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

Original text of this message