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

1 vote337 views10 answers
Stack overflow
SQL
11 votes353 views5 answers
How to install sqlite3 python
SQL
2 votes381 views1 answer
Mysql trigger after update
SQL
0 vote443 views1 answer
Compress sql file database ubuntu
SQL
3 votes358 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
19 votes371 views3 answers
How to change column type psql
SQL
0 vote332 views1 answer
Mysql export data with a where clause
SQL
1 vote345 views1 answer
Apex select list ORA-20999
SQL
1 vote341 views1 answer
Postgres get timestamp
SQL
4 votes375 views2 answers
Truncate oracle
SQL