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

56 votes580 views5 answers
Psql create user
SQL
0 vote172 views1 answer
Get who is hired in specific month in sql
SQL
0 vote187 views1 answer
Oracle table free space
SQL
0 vote210 views1 answer
TSQL function split string
SQL
1 vote182 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote174 views2 answers
Sql join on wildcard
SQL
0 vote228 views1 answer
Parent and child link in mysql
SQL
0 vote164 views5 answers
Sql table intermédiaire
SQL
0 vote175 views1 answer
Longtext sql
SQL
2 votes238 views1 answer
Mysql now format
SQL