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

12 votes104 views1 answer
Docker mysql random root password
SQL
2 votes128 views2 answers
Null column to 0 in mysql
SQL
0 vote112 views1 answer
Sql python hwo to pass a list in paramerter
SQL
3 votes99 views4 answers
Show sql server database
SQL
0 vote74 views2 answers
Avg() sql
SQL
0 vote117 views1 answer
Sql field equals multiple values
SQL
0 vote98 views1 answer
Group by two columns postgres
SQL
4 votes97 views1 answer
Sql any
SQL
5 votes262 views2 answers
How to ascending order in sql
SQL
0 vote94 views1 answer
Timestamp(0) postgresql
SQL