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 vote197 views1 answer
Providername system.data. mysql
SQL
4 votes182 views3 answers
Copy table postgres
SQL
0 vote162 views1 answer
Mysql update sum same table
SQL
0 vote183 views1 answer
Drop all data from tables
SQL
34 votes184 views6 answers
Sql change data type
SQL
0 vote189 views1 answer
Is not numeric sql
SQL
2 votes184 views1 answer
Set username and password for postgresql database
SQL
6 votes174 views1 answer
Rank function in oracle with example
SQL
3 votes182 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote179 views1 answer
Find number of entries sql
SQL