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 vote184 views1 answer
Store case result sql
SQL
0 vote135 views1 answer
Find usage of table in sql server
SQL
0 vote197 views1 answer
Mysql grant access to one database
SQL
3 votes140 views1 answer
Oracle drop user
SQL
0 vote149 views1 answer
Oracle list user locked
SQL
7 votes168 views1 answer
Show line number in sql server
SQL
1 vote147 views2 answers
Sql insert timestamp
SQL
0 vote152 views1 answer
Manage Database in MySQL
SQL
4 votes133 views4 answers
Print pl sql
SQL
0 vote131 views2 answers
Sqlite unix timestamp
SQL