Oracle calculated 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 vote334 views1 answer
Get all employees if name ends with in sql
SQL
1 vote368 views4 answers
Sql now
SQL
0 vote357 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote362 views1 answer
Oracle procedure chain step
SQL
1 vote405 views2 answers
Mysql limit offset
SQL
2 votes332 views1 answer
Mysql list users on ubuntu
SQL
0 vote361 views1 answer
Mysql persistence.xml
SQL
0 vote364 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote378 views1 answer
Sql menampilkan data tabel
SQL
1 vote358 views1 answer
Mysql query bulk insert
SQL