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 vote218 views1 answer
Combine 2 columns search query mysql
SQL
0 vote183 views1 answer
Authentication in sql server
SQL
21 votes196 views4 answers
Oracle add column
SQL
0 vote307 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote273 views1 answer
Trigger
SQL
0 vote268 views1 answer
Sql select max value for each group
SQL
0 vote198 views1 answer
Ver usuarios mysql
SQL
0 vote189 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote204 views1 answer
How to find lowest in sql
SQL
1 vote218 views1 answer
Sql server loop over query
SQL