Re: Designer6i, Allowable values code table

If the values for a particular look-up change frequently, I'd just build a separate table with the values and run a foreign key to it. Then you can put together a module out of Designer to maintain the lookup table. For lookup tables the designer generated modules may be acceptable without any mods, in which case you can put one together in 10-15 minutes.

SUSOTT_at_amnutrition.com wrote:
> We are running Oracle 8i/Designer6i on windows2000 server. In building
> tables, we have several columns where we need to limit the values allowed,
> but also allow for the addition/deletion of the allowed values. It was
> pointed out that Oracle has a dynamic allowable values table which should
> satisfy our requirements. I understand that we can change the allowable
> values in the respository and generate the table into the instance. That
> the only requirement to use the new values is for the application to be
> restarted. The "help" text states that there is no procedure to remove
> unused values. Would the DBA be able to go into the table directly and
> remove unused values? Would you provide any other thoughts on this as we
> are new to Oracle and its way of thinking?
>
>
Received on Sat Apr 13 2002 - 06:33:32 CEST