Unix Technical Forum

How to add "reference calculation" columns in design tables?

This is a discussion on How to add "reference calculation" columns in design tables? within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hello I have created a design table and want to add columns within the table that DO NOT drive ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 10:14 AM
Bullman
 
Posts: n/a
Default How to add "reference calculation" columns in design tables?

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 10:14 AM
Bullman
 
Posts: n/a
Default Sorry wrong forum

Please delete this thread...wrong forum

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-08-2008, 10:14 AM
DA Morgan
 
Posts: n/a
Default 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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com