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 vote223 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
1 vote626 views1 answer
How to lock table in mysql
SQL
7 votes211 views2 answers
N highest salary in sql
SQL
0 vote208 views1 answer
Mysql query problems and solutions
SQL
0 vote256 views1 answer
Tsql find procedure with name
SQL
0 vote208 views1 answer
Select only one row sql
SQL
34 votes239 views5 answers
Oracle alter table add column
SQL
1 vote279 views1 answer
How to get alternate records from a table in sql
SQL
3 votes215 views1 answer
Fk in insert mysql
SQL
0 vote293 views1 answer
Trigger
SQL