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 vote148 views1 answer
Sql find table by name
SQL
0 vote140 views1 answer
Postgres declare variable
SQL
0 vote149 views1 answer
Java check if something is in mysql table
SQL
2 votes132 views1 answer
Match in sql server
SQL
1 vote132 views1 answer
Declare table variable
SQL
0 vote155 views1 answer
Merge clause with inner join
SQL
0 vote141 views3 answers
Mysql delete if not in another table
SQL
0 vote138 views1 answer
Uncomment listen_address=localhost
SQL
0 vote143 views1 answer
Heidisql check how much space a row
SQL
12 votes145 views1 answer
Script to add new column in table sql
SQL