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

10 votes109 views2 answers
Django mysql
SQL
0 vote184 views1 answer
Mysql best varchar length size
SQL
1 vote152 views1 answer
Oracle start job
SQL
4 votes161 views1 answer
Mac install mysql
SQL
0 vote125 views1 answer
Oracle sysdba connect as another user
SQL
37 votes197 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
2 votes154 views2 answers
Oracle multiple insert
SQL
0 vote186 views1 answer
Oracle date summer time
SQL
1 vote230 views1 answer
Sql server delete top 1000
SQL
42 votes228 views6 answers
Sql query duplicate rows
SQL