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

0 vote172 views1 answer
Oracle sql procedure return value
SQL
0 vote174 views1 answer
Sqldf change user
SQL
6 votes184 views1 answer
Sqlite foreign key
SQL
7 votes183 views1 answer
Mysql iif
SQL
1 vote203 views1 answer
Mysql update inner
SQL
0 vote182 views1 answer
Oracle archivemode
SQL
1 vote190 views1 answer
Mysql column start with string
SQL
1 vote200 views1 answer
Oracle split string
SQL
9 votes194 views3 answers
Find all tables with column name
SQL
1 vote181 views2 answers
Sql groub by count
SQL