Oracle calculated 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 vote216 views1 answer
Mariadb number format
SQL
26 votes218 views6 answers
Modify column name in sql
SQL
1 vote205 views1 answer
Mysql remove last empty newline
SQL
0 vote227 views1 answer
Php select data from mysql database without column name
SQL
0 vote223 views1 answer
Mysqlcli how to load external sql file
SQL
4 votes216 views1 answer
List tables sqlite
SQL
1 vote162 views1 answer
Postgres reset auto increment
SQL
0 vote216 views1 answer
Oracle running queries sql
SQL
5 votes235 views1 answer
Sql table columns
SQL
1 vote222 views1 answer
Rename table column name in mysql
SQL