Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Computed column?
Jane Mikityanskaya <jane_at_hnrc.tufts.edu> wrote in article
<33CA84D9.A866545C_at_hnrc.tufts.edu>...
> Working with Oracle Rdb, I was spoiled by possibility of creating
> 'computed by' columns.
> For example, creating table ' Test' I could define:
> column A integer,
> column b integer,
> column c as (a+b)/10;
> Since there is no such feature in Oracle 7.3, can someone tell me a work
> around for 'computed' fields?
>
> Regards,
> Jane
>
use a view (i'm sure rdb uses this technique also 'under the hood'):
create table TestBase
(A integer,
b integer);
create view Test
as select a, b, (a+b)/10 as c
from TestBase;
gert Received on Tue Jul 15 1997 - 00:00:00 CDT