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 vote163 views1 answer
Default column value in sql same as another column laravel
SQL
-1 vote175 views1 answer
How to Activate the database
SQL
0 vote131 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote177 views1 answer
Eliminate zero from integer mysql
SQL
0 vote295 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
1 vote144 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote145 views2 answers
Create new table plsql
SQL
1 vote142 views1 answer
Oracle first row
SQL
1 vote161 views1 answer
Join to find results not in another table
SQL
46 votes220 views4 answers
Create column sql
SQL