Oracle SQL how to make database calculate a column?

Question

I want to make database calculate a column. For example: There is a column named 'price'. every time I insert a new value into the price, I want another column named 'percent' automatically calculate 1% of the new value. Like this;

Price     Percent
100        1
250        2,5

How can I create this?

So you are saying that if the price of something is 100, that price is 1% of .... what? — EdStevens
– EdStevens, Commented Dec 8, 2020 at 14:20

Littlefoot · Accepted Answer · 2020-12-08 11:20:39Z

3

Create a virtual column:

SQL> create table test
  2    (price       number,
  3     percent     number as (price * 0.01)        --> this
  4    );

Table created.

SQL> insert into test(price)
  2  select 100 from dual union all
  3  select 250 from dual;

2 rows created.

SQL> select * From test;

     PRICE    PERCENT
---------- ----------
       100          1
       250        2,5

SQL>

answered Dec 8, 2020 at 11:20

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL how to make database calculate a column?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related