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

16 votes336 views2 answers
Add column if not exists mysql
SQL
14 votes402 views1 answer
How to export db from mysql
SQL
1 vote316 views1 answer
Lpad function in sql oracle
SQL
3 votes307 views1 answer
Pl sql check if variable is empty
SQL
0 vote312 views1 answer
Postgresql update to unique
SQL
1 vote293 views1 answer
Postgres kill pid
SQL
0 vote314 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote325 views2 answers
Sql trigger difference between for and after
SQL
0 vote338 views2 answers
Nosqlbooster query other collection
SQL
25 votes328 views6 answers
Change column name mysql
SQL