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 vote159 views1 answer
Where name ends in SQL
SQL
0 vote156 views1 answer
Dns slave zone convert
SQL
-1 vote167 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote169 views3 answers
Sql select statements
SQL
0 vote153 views1 answer
What is logical database schema
SQL
2 votes199 views1 answer
Sql compare strings
SQL
14 votes156 views2 answers
Sql cast
SQL
0 vote154 views1 answer
Java mysql date format
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL
5 votes162 views3 answers
Bash: mysql: command not found
SQL