Oracle calculated 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

2 votes144 views1 answer
Foreign key example in dbms
SQL
1 vote182 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote200 views1 answer
Oracle calculate statistics on partition
SQL
0 vote189 views1 answer
Php delete database
SQL
1 vote147 views1 answer
Enable mysql slow query log
SQL
0 vote229 views1 answer
Sql character index
SQL
0 vote196 views1 answer
Mysql update from n to 100
SQL
3 votes209 views1 answer
Oracle function return
SQL
3 votes208 views2 answers
Having in mysql
SQL
4 votes183 views1 answer
Oracle table statistics last analyzed
SQL