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 vote356 views1 answer
Count number of entires by months sql
SQL
1 vote347 views1 answer
Retrieve meaning
SQL
3 votes339 views2 answers
Brew restart mysql
SQL
1 vote340 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote367 views1 answer
Left join vs inner join performance
SQL
2 votes332 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote359 views1 answer
How to find symmetric pairs in sql
SQL
0 vote329 views1 answer
Mysql docker image for macbook m1
SQL
0 vote354 views1 answer
Load data from text file to mysql database on mac terminal
SQL
1 vote360 views1 answer
Postgres set column based on another column
SQL