Oracle virtual 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 vote212 views1 answer
How to get one year old query from plan cache
SQL
11 votes202 views1 answer
Ddl materialized view
SQL
0 vote214 views1 answer
Clone table structure mysql
SQL
0 vote209 views1 answer
Postgresql replace html tags from string
SQL
12 votes220 views1 answer
Run mysql instance in docker
SQL
0 vote209 views1 answer
Insert using condition postgres
SQL
5 votes286 views1 answer
Oracle sysdate - 1 month
SQL
2 votes210 views1 answer
Oracle convert run_duration to number
SQL
0 vote212 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote194 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL