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

0 vote321 views1 answer
Multiple tricky query in sql server
SQL
0 vote298 views1 answer
Mysql percentage of total
SQL
0 vote339 views1 answer
How to install postgresql on wsl
SQL
2 votes331 views4 answers
List databases in sql server
SQL
8 votes325 views2 answers
Change name of colum in sql table
SQL
23 votes313 views6 answers
Delete all rows from table sql
SQL
3 votes320 views1 answer
Oracle user privileges
SQL
0 vote348 views1 answer
Mysql best varchar length size
SQL
0 vote347 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote372 views1 answer
Oracle chain step succeeded
SQL