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 vote140 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
2 votes137 views2 answers
Set value to null sql
SQL
0 vote139 views1 answer
Bigrock database connection string
SQL
0 vote121 views1 answer
Get initials name in sql
SQL
0 vote108 views2 answers
Mysql regexp match word
SQL
0 vote114 views1 answer
Dump multiple tables mysql
SQL
-1 vote75 views3 answers
Ubuntu install mssql
SQL
0 vote121 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote120 views1 answer
Oracle sql generate list of days
SQL
2 votes135 views1 answer
Mysql id of inserted row
SQL