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

0 vote232 views1 answer
Change schema of all tables postgres
SQL
0 vote247 views1 answer
Get date ISO in psql
SQL
1 vote222 views4 answers
Fatal database postgres does not exist
SQL
3 votes257 views5 answers
Foreign keys
SQL
31 votes230 views1 answer
Postgresql add column with constraint
SQL
1 vote226 views2 answers
End mysql command
SQL
0 vote240 views1 answer
Mysql grant grant option
SQL
0 vote242 views1 answer
Sql last 3 rows
SQL
-1 vote225 views1 answer
Export mysql table to file
SQL
13 votes251 views4 answers
Command line mysql import
SQL