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

2 votes101 views1 answer
Sql missing records from another table
SQL
1 vote134 views1 answer
Find size of all DB's postgres
SQL
10 votes108 views4 answers
SELECT FROM WHERE
SQL
1 vote102 views1 answer
List index mysql cli
SQL
0 vote102 views1 answer
QUERY JPQL
SQL
0 vote102 views1 answer
Sql server get date of previous sunday
SQL
1 vote98 views1 answer
Oracle aleter trigger ora-01031
SQL
9 votes125 views6 answers
Oracle substring
SQL
17 votes96 views4 answers
Show tables sql server
SQL
1 vote94 views1 answer
Oracle check table space
SQL