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 vote297 views1 answer
Why do we need data structure in sql
SQL
1 vote263 views1 answer
Sql server 2016 reseed identity
SQL
4 votes265 views3 answers
Mysql update with join
SQL
3 votes255 views2 answers
Sqlite show table definition
SQL
0 vote276 views1 answer
Drop database using terminal postgres
SQL
1 vote264 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
3 votes273 views2 answers
Sql paging query
SQL
4 votes260 views3 answers
Mysql modify foreign key
SQL
11 votes256 views2 answers
Safe mode off mysql
SQL
14 votes259 views1 answer
Excel is not a database
SQL