Oracle generated 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 vote126 views1 answer
Sql date with year
SQL
0 vote110 views1 answer
Python sqlalchemy connection show server
SQL
0 vote97 views1 answer
Sql quary intervewi question
SQL
1 vote109 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
3 votes100 views3 answers
Stop mysql ubuntu
SQL
4 votes108 views1 answer
Conda install sqlalchemy
SQL
0 vote100 views1 answer
Delete data from database sqlite android
SQL
0 vote96 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote96 views2 answers
2nd max salary query in sql
SQL
0 vote104 views1 answer
Helptext in sql
SQL