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

3 votes137 views1 answer
Sql is not like
SQL
1 vote122 views1 answer
Reutrn string after character sql
SQL
8 votes168 views1 answer
Racle create auto increment column
SQL
2 votes132 views1 answer
Get hour from date sql
SQL
1 vote123 views1 answer
Copy postgres table from one schema into another
SQL
0 vote176 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote138 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote80 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote119 views1 answer
What is int in mysql
SQL
1 vote138 views2 answers
Sql convert datetime to year month
SQL