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 vote117 views1 answer
Netstat -tln mysql
SQL
1 vote120 views1 answer
Sql delete row with auto increment
SQL
0 vote116 views1 answer
Sql get date from timestamp
SQL
0 vote131 views1 answer
Search starting with mysql
SQL
1 vote139 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote132 views1 answer
Quit mysql
SQL
19 votes131 views6 answers
Sql server drop table if exists
SQL
0 vote141 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote145 views1 answer
Leftjoin in sql
SQL
1 vote129 views1 answer
Alter add syntax
SQL