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

5 votes219 views3 answers
Day of week postgresql
SQL
0 vote213 views1 answer
How to put value in parameters in mysqldataadapter
SQL
2 votes206 views1 answer
Sqlite show table indexes
SQL
3 votes220 views1 answer
Oracle APEX elapsed time
SQL
2 votes252 views1 answer
Find column in all stored procedures sql server
SQL
40 votes253 views4 answers
PostgreSQL add column
SQL
0 vote252 views1 answer
Show all sequences postgres
SQL
0 vote226 views1 answer
Varchar2 length in oracle
SQL
2 votes220 views1 answer
Mysql trigger after update
SQL
0 vote223 views1 answer
Mysql database hyphen
SQL