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 vote148 views1 answer
Make parameters nullable in sql server
SQL
0 vote124 views1 answer
Load utilities in sql server
SQL
4 votes125 views1 answer
Oracle session date format
SQL
2 votes166 views1 answer
Insert from table tsql
SQL
0 vote143 views1 answer
Select all columns except one sql
SQL
0 vote127 views1 answer
Date diff sql
SQL
0 vote137 views1 answer
Call object contructor and call methods of object
SQL
20 votes144 views1 answer
Sql change column types
SQL
0 vote158 views1 answer
Character count sql
SQL
-1 vote132 views3 answers
Check table exist postgresql
SQL