Columns [message #78027] |
Fri, 04 January 2002 10:47 |
Paul
Messages: 164 Registered: April 1999
|
Senior Member |
|
|
We are in the process of developing an Oracle Database and are exploring the possiblities of creating a column that uses the computations of other columns and performs several logical tests of its own. We are wondering how to make this column appear only when we need to run queries against it so that we do not have to populate it and waste space. We believe this is possible but are unsure of how to go about accomplishing it. Any help and/or suggestions would be greatly appreciated. Thank you for your assistance.
----------------------------------------------------------------------
|
|
|
Re: Columns [message #78045 is a reply to message #78027] |
Mon, 07 January 2002 07:07 |
Robin
Messages: 73 Registered: October 2001
|
Member |
|
|
Dear Paul,
I think view can solve ur problem. There u can make new column by calculating field of different
cilumn, use column alias.
Thank
Robin
|
|
|