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 vote126 views1 answer
Import sql mysql ubuntu
SQL
1 vote165 views1 answer
Oracle plan hash value
SQL
3 votes130 views3 answers
Concatenation in sql
SQL
0 vote166 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote205 views1 answer
SQL query to verify the size of the table
SQL
1 vote182 views1 answer
Postgresql if 0 then 1
SQL
0 vote164 views1 answer
Sql describe
SQL
0 vote135 views1 answer
If null don't update
SQL
0 vote158 views2 answers
Sqlalchemy default value for column
SQL
3 votes123 views1 answer
Difference sql vs mysql
SQL