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 vote48 views2 answers
Oracle select
SQL
14 votes46 views3 answers
Sql trim from string
SQL
0 vote51 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
4 votes43 views1 answer
Postgresql list sequences
SQL
0 vote42 views1 answer
Mysql Error Code: 1005
SQL
0 vote61 views1 answer
Updating database in sql
SQL
0 vote41 views1 answer
Insert thai language sql server
SQL
9 votes51 views6 answers
Sql add column with default value
SQL
0 vote51 views2 answers
Add colum in sql
SQL
7 votes56 views2 answers
How to create index mysql
SQL