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

20 votes184 views1 answer
Get all table name in sql through php
SQL
8 votes179 views3 answers
Duplicate entry
SQL
1 vote201 views2 answers
Mssql show database size
SQL
9 votes187 views2 answers
Mysql change value
SQL
0 vote201 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote193 views1 answer
Split string by comma in sql server
SQL
79 votes574 views6 answers
Grepper code
SQL
2 votes213 views1 answer
Install postgresql centos 5
SQL
2 votes223 views2 answers
Calculate percentage in sql
SQL
0 vote197 views1 answer
One table with another
SQL