oracle calculated column

Solutions on MaxInterview for oracle calculated column by the best coders in the world

showing results for - "oracle calculated column"
Irene
14 Oct 2017
1CREATE TABLE T1 (
2    ID          NUMBER,
3    PRODUCT     VARCHAR2(50),
4    PRICE       NUMBER(10, 2),
5    TAXED_PRICE NUMBER(10, 2) GENERATED ALWAYS AS (round(PRICE * 1.2, 2)) VIRTUAL
6);
7INSERT INTO T1 (ID, PRODUCT, PRICE) VALUES (1, 'Spoon', 12);