Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 UKReceived on Thu Sep 18 2003 - 03:51:16 CDT
![]() |
![]() |