Oracle virtual 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

3 votes256 views4 answers
Show columns from table
SQL
9 votes290 views4 answers
How to alter table column name in mysql
SQL
0 vote294 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote273 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote236 views1 answer
Insert into sql
SQL
0 vote286 views1 answer
Running mysql from bash sc
SQL
0 vote287 views1 answer
Lost connection to mysql
SQL
0 vote278 views1 answer
Last date for each user sql
SQL
6 votes260 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote293 views1 answer
The package java.sql is not accessible
SQL