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 vote348 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote326 views1 answer
Download mysql database to excel in android studio
SQL
1 vote337 views2 answers
Datetrunc hour snowflake
SQL
1 vote345 views4 answers
Sql now
SQL
1 vote335 views1 answer
Pagination sql
SQL
6 votes329 views4 answers
Eloquent to sql with bindings
SQL
9 votes325 views3 answers
Sequence postgresql
SQL
0 vote342 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote335 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote342 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL