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

0 vote338 views1 answer
Psotgres multiple values
SQL
0 vote334 views2 answers
Mysql create table if not exists
SQL
2 votes312 views1 answer
Oracle table size
SQL
0 vote370 views1 answer
Query for backup a database at another location in file system
SQL
0 vote353 views1 answer
Sql date with year
SQL
0 vote310 views1 answer
Select last 2 characters sql
SQL
3 votes322 views1 answer
Oracle revoke grant
SQL
0 vote340 views1 answer
How to see password mysql vestacp
SQL
13 votes334 views6 answers
Mysql remove duplicates
SQL
1 vote349 views1 answer
Update from select oracle
SQL