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

1 vote267 views1 answer
Sql server kill all connections
SQL
0 vote257 views1 answer
Pl/sql loop example
SQL
0 vote261 views1 answer
Increase speed of like queries postgres
SQL
-1 vote265 views2 answers
Get day in sql
SQL
0 vote274 views1 answer
Top frequency in sql server
SQL
6 votes281 views3 answers
Oracle all dates between two dates
SQL
1 vote256 views2 answers
Limit sqlserver
SQL
2 votes226 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote263 views1 answer
Oracle current session details
SQL
0 vote261 views1 answer
Join in update query in mysql
SQL