Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to add "reference calculation" columns in design tables?
Bullman wrote:
> Hello
>
> I have created a design table and want to add columns within the table
> that DO NOT drive any dimensions but are there as "reference" numbers
> to assist any user editing the design table.
>
> eg. a calculated column that tells the user what the maximum dimension
> can be for the dimension referenced by the dimension driving cell next
> to it.
>
> I think I can recall doing something like this in the past and perhaps
> used some syntax that used the term "statement".
>
> Thanks in advance.
>
> Bullman
I have no idea what you are trying to do. If you want to add columns then add them. What's this issue? Though in a relational design I would expect that what you need is a second table that could be referenced as a lookup.
You will need to be far clearer in your explanation: At least for me.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Aug 29 2006 - 13:50:21 CDT