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

1 vote218 views1 answer
Mysql show current queries
SQL
0 vote213 views1 answer
How to get nth number in sql
SQL
0 vote222 views1 answer
Leftjoin in sql
SQL
1 vote195 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote200 views1 answer
Sql values that contains certain multiple ids
SQL
1 vote227 views1 answer
Mysql select and count left join
SQL
0 vote200 views1 answer
Get who is hired in february in sql
SQL
0 vote196 views1 answer
Sql list dates between two dates
SQL
0 vote197 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote239 views1 answer
Create relationship with betwen two tables in postgersql
SQL