Oracle virtual column

CREATE TABLE T1 (
    ID          NUMBER,
    PRODUCT     VARCHAR2(50),
    PRICE       NUMBER(10, 2),
    TAXED_PRICE NUMBER(10, 2) GENERATED ALWAYS AS (round(PRICE * 1.2, 2)) VIRTUAL
);
INSERT INTO T1 (ID, PRODUCT, PRICE) VALUES (1, 'Spoon', 12);

Similar codes

0 vote195 views1 answer
Hallo
SQL
3 votes199 views3 answers
Docker create postgresql database
SQL
10 votes200 views1 answer
Oracle dependency
SQL
3 votes208 views1 answer
Show index table
SQL
16 votes254 views3 answers
T-SQL Add Column
SQL
5 votes236 views4 answers
Traduction
SQL
0 vote234 views1 answer
Sql server alter table add column tinyint
SQL
15 votes207 views2 answers
Sql order by multiple columns
SQL
0 vote223 views1 answer
Exclude last comma separated string mysql
SQL
46 votes230 views4 answers
Create column sql
SQL