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 vote153 views1 answer
Postgres row expiration
SQL
2 votes126 views1 answer
Sql column values comma separated
SQL
0 vote134 views1 answer
How to drop a trigger in postgresql
SQL
0 vote150 views1 answer
How to fetch data from database in sql
SQL
0 vote169 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote127 views1 answer
Postgres jsonb array push new element
SQL
0 vote132 views1 answer
Mariadb select limit offset
SQL
4 votes122 views3 answers
Sql drop database if exists
SQL
28 votes124 views4 answers
Show tables mysql
SQL
53 votes307 views6 answers
Sql server alter column
SQL