Oracle generated 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 vote406 views1 answer
Traccar mysql
SQL
0 vote409 views1 answer
How to add mysql to path on termin after installation
SQL
3 votes355 views2 answers
Mysql create timestamp column
SQL
0 vote313 views1 answer
Flask_sqlalchemy install
SQL
15 votes340 views2 answers
How to know the username of postgresql
SQL
1 vote380 views1 answer
Oracle datafile max size 32gb
SQL
0 vote358 views1 answer
Turnicate in mysql
SQL
0 vote349 views1 answer
Sql server split string and insert into table select
SQL
40 votes404 views6 answers
Update table mysql
SQL
0 vote425 views1 answer
What logs are available on RDS MySQL?
SQL