Oracle virtual 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 vote93 views2 answers
Get top 1 row of each group
SQL
0 vote106 views2 answers
Oracle chain rules
SQL
17 votes100 views6 answers
Mysql import sql file
SQL
5 votes113 views4 answers
Upload database mysql command line
SQL
1 vote108 views1 answer
Convert varchar to int in sqlite
SQL
1 vote114 views1 answer
Sample clause in sql
SQL
0 vote115 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote93 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote109 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
2 votes115 views2 answers
Mysql alter column default
SQL