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 vote269 views2 answers
Postgresql check privileges on schema
SQL
6 votes221 views2 answers
Return columns from table sql
SQL
0 vote220 views1 answer
Postgresql copy backup table
SQL
0 vote245 views1 answer
How to install sql in anaconda
SQL
34 votes246 views5 answers
Oracle alter table add column
SQL
0 vote241 views2 answers
Oracle select
SQL
3 votes229 views1 answer
Mssql remove column
SQL
25 votes231 views6 answers
Modify column name in mysql
SQL
0 vote229 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote244 views1 answer
Oracle select partition
SQL