Generated column

[ManuGenard]

Hi,

Is there a way in Oracle to create a table with some of the columns automatically populated.
Let's say I have 3 amount columns and I want to the third to be the total of the 2 previous one.
I know I can use a trigger to do that, but my question is, is there a way to have that directly included in the table DDL just as in DB2 for example:
create table myTable (col1 integer, col2 integer, col3 GENERATED ALWAYS AS (col1+col2))

Anyone knows ??

 

[THoey]

I don't think so because that is considered bad database design to have a "derived column". If a column's value can be resolved from two other columns, you shouldn't keep in in most occaissions. Besides, what happens if one of the fields is updated?

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...