Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: user configurable columns

Re: user configurable columns

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 18 Sep 2003 09:51:16 +0100
Message-ID: <3f697204$0$15780$ed9e5944@reading.news.pipex.net>


"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
Received on Thu Sep 18 2003 - 03:51:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US