Re: Computed column?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 1997/07/16
Message-ID: <01bc922b$bb169680$160a14ac@SteveIP.corp.sierra.com>#1/1

Uh, isn't kinda bad relational form (i.e., violates the 3rd Normal rule) to store, in a table, a field which can be entirely derived from some other fields in the same record of the table?

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
>
>
>
Received on Wed Jul 16 1997 - 00:00:00 CDT