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

45 votes254 views5 answers
Grant all privileges mysql
SQL
0 vote240 views1 answer
Sqlite unique multiple columns
SQL
16 votes228 views4 answers
Sort by sql
SQL
2 votes213 views1 answer
Install sqlite npm
SQL
8 votes231 views1 answer
Oracle create datafile
SQL
34 votes266 views6 answers
Alter table add foreign key mysql
SQL
0 vote247 views1 answer
Trigger stock phpmyadmin
SQL
0 vote242 views1 answer
How to map sql column to custom names
SQL
-1 vote236 views5 answers
Not in sql
SQL
0 vote235 views1 answer
Default column value in sql same as another column laravel
SQL