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

1 vote155 views1 answer
Mysql drop key
SQL
0 vote143 views1 answer
Equi joins in oracle
SQL
0 vote176 views1 answer
Oracle date summer time
SQL
0 vote213 views1 answer
Postgres rename database
SQL
7 votes161 views3 answers
Python and mysql connectivity
SQL
3 votes143 views2 answers
Mysql add 2 hours
SQL
1 vote196 views2 answers
Laravel jwt generate token
SQL
1 vote163 views1 answer
Add current timestamp in mysql
SQL
4 votes147 views1 answer
Sql delete where in select
SQL
1 vote140 views1 answer
T-sql find object by name
SQL