Oracle generated 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 vote280 views1 answer
How to lock table in mysql
SQL
0 vote287 views1 answer
SQL Where-Klausel
SQL
0 vote284 views1 answer
Example database query
SQL
1 vote281 views1 answer
Postgres set sequence value to max id
SQL
5 votes278 views1 answer
Purge undo tablespace usage
SQL
3 votes267 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
1 vote275 views1 answer
Add multiple row table pl sql
SQL
0 vote285 views1 answer
Get clob size oracle
SQL
0 vote293 views2 answers
Coursera spark sql max count
SQL
22 votes336 views4 answers
Mysql format date
SQL