Oracle virtual 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 vote202 views1 answer
Typical max-connect-errors mysql
SQL
0 vote265 views1 answer
Get enginge db mysql
SQL
13 votes204 views4 answers
Command line mysql import
SQL
3 votes185 views1 answer
Oracle user quota unlimited
SQL
28 votes192 views6 answers
Mysql change user password
SQL
0 vote278 views1 answer
Mysql readable output
SQL
0 vote267 views1 answer
Alter database name script
SQL
0 vote218 views1 answer
Call function in query sql server
SQL
0 vote197 views1 answer
Hoq to import database source
SQL
0 vote197 views1 answer
Rename constraint postgresql
SQL