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 vote277 views2 answers
Return the number of records in a single table mysql
SQL
0 vote272 views1 answer
Convert sql server guid to varbinary
SQL
2 votes275 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote289 views1 answer
Jooq convert using gbk
SQL
0 vote294 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
7 votes290 views5 answers
Show details of table postgres
SQL
8 votes285 views3 answers
Postgres connection string
SQL
2 votes278 views2 answers
Postgresql date at timezone
SQL
0 vote286 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote300 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL