Oracle generated 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 vote352 views1 answer
Mysql strict_trans_tables
SQL
1 vote337 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
13 votes363 views2 answers
Get date from now() mysql
SQL
2 votes348 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote341 views1 answer
Oracle current session details
SQL
11 votes333 views4 answers
Query DISTINCT
SQL
-1 vote336 views1 answer
Mysql change database charset and collation
SQL
8 votes376 views6 answers
Insert command in sql
SQL
0 vote345 views1 answer
Sql composite key
SQL
103 votes562 views1 answer
Like sql
SQL