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 vote193 views1 answer
Call function sql oracle with output put line
SQL
3 votes151 views2 answers
Mysql config user password
SQL
0 vote180 views2 answers
Getting customers with no orders sql
SQL
18 votes175 views2 answers
Sql comments
SQL
0 vote154 views1 answer
Python connect microsoft sql server
SQL
8 votes165 views1 answer
Declare table variable sql server
SQL
16 votes145 views4 answers
Sort by sql
SQL
1 vote170 views1 answer
Autocommit mysql
SQL
0 vote111 views1 answer
Deleted table in sql trigger
SQL
0 vote156 views3 answers
Sql server import json
SQL