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 vote322 views1 answer
Convert sql server guid to varbinary
SQL
0 vote431 views1 answer
How to rename a database in tsql
SQL
1 vote321 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote341 views1 answer
Como hacer una consulta en sql
SQL
0 vote318 views1 answer
Mysql remove tabs from string
SQL
2 votes330 views1 answer
Oracle drop sequence if exists
SQL
2 votes309 views1 answer
Sql find missing values between two tables
SQL
0 vote337 views3 answers
Sql drop all tables
SQL
1 vote348 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote283 views1 answer
Import csv to mysql
SQL