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

9 votes303 views2 answers
Nosql databases
SQL
5 votes288 views2 answers
Mysql import gzip db
SQL
0 vote288 views1 answer
Duplix print in Smartforms
SQL
0 vote561 views1 answer
Power bi connect to postgresql
SQL
0 vote285 views1 answer
Oracle dynamic select into
SQL
2 votes286 views2 answers
Mysql find max value row
SQL
0 vote306 views1 answer
Implode in sql query
SQL
0 vote226 views1 answer
Copy table dbeaver
SQL
0 vote298 views2 answers
Unique key
SQL
27 votes337 views3 answers
Mysql delete row
SQL