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

1 vote104 views1 answer
Sqlite create index
SQL
1 vote108 views1 answer
Mysql find tables with column name
SQL
0 vote108 views1 answer
Mysql add comment to column
SQL
0 vote96 views1 answer
Change default schema sql server
SQL
2 votes157 views1 answer
Oracle Column Names of a table
SQL
0 vote99 views3 answers
Get free card roblox
SQL
0 vote102 views1 answer
Start stop mysql linux
SQL
0 vote116 views1 answer
Oracle running queries sql
SQL
0 vote124 views1 answer
Create dump file mysql workbench
SQL
2 votes109 views1 answer
Oracle index size
SQL