Re: user configurable columns

"roger" <rsr_at_rogerware.com> wrote in message news:Xns93F9D5C2A41Frsrrogerwarecom_at_204.127.204.17... <snip>
> I need to do a pretty similar kind of thing to that -
> to allow the "user" be able to dynamically define their
> own set of configurable attributes that are stored along
> with the standard attributes (columns) for various objects
> (rows in a table) that are part of an application schema.

We have a 3rd party app that has a structure like

create table attribute(

ATT_NAME              VARCHAR2(8),
ATTRIBUTE_ID        VARCHAR2(2),
DATA_LENGTH       NUMBER(15),
DATA_TYPE             VARCHAR2(1),
DESCRIPTION          VARCHAR2(50));

 and

create table att_value(

ATTRIBUTE_ID         VARCHAR2(2),
DESCRIPTION          VARCHAR2(50)
ATT_VALUE              VARCHAR2(12));

Which works pretty well.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK