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 vote305 views1 answer
Match end of string regex sql
SQL
5 votes319 views3 answers
Mysql remove unique constraint
SQL
1 vote304 views1 answer
Declare variables sql
SQL
-1 vote289 views1 answer
Mysql coalesce
SQL
0 vote296 views1 answer
Sql server split string and insert into table select
SQL
0 vote314 views1 answer
OFFSET consulta mysql
SQL
0 vote296 views1 answer
How to query all tables mysql at the same time
SQL
0 vote310 views1 answer
Postgresql find missing id
SQL
5 votes308 views3 answers
Oracle first day of last year
SQL
2 votes310 views1 answer
How to delete view in sql
SQL