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 vote465 views1 answer
How to show current database in mysql
SQL
0 vote387 views1 answer
Oracle swap partition
SQL
2 votes435 views3 answers
Mysql unix timestamp to date
SQL
1 vote370 views3 answers
How to get date in sql
SQL
6 votes348 views2 answers
Mysql check auto increment value
SQL
0 vote341 views1 answer
Json not contains mysql
SQL
12 votes345 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote345 views1 answer
Json_remove mysql
SQL
0 vote390 views1 answer
View psql output in horizontal scrolling
SQL
4 votes360 views1 answer
SQL find text in SP
SQL