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 vote292 views1 answer
Convert sql server guid to varbinary
SQL
2 votes329 views2 answers
Get all tables using like
SQL
0 vote299 views1 answer
Sql datediff month
SQL
0 vote282 views7 answers
10 random questions use python and SQL
SQL
0 vote250 views1 answer
Check id exist or not in sql
SQL
0 vote319 views1 answer
Oracle for loop on list
SQL
22 votes311 views3 answers
SQL CHEATSHEET
SQL
0 vote313 views1 answer
To Create directory
SQL
8 votes338 views3 answers
SQL column name
SQL
0 vote303 views1 answer
Data structures in sql
SQL