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

1 vote110 views2 answers
Postgres copy table from one schema to another
SQL
3 votes117 views2 answers
Truncate all tables
SQL
0 vote117 views1 answer
Create column that already exists mysql
SQL
2 votes118 views1 answer
Mysql sysdate
SQL
0 vote124 views2 answers
How to create a table from another table in sql derby
SQL
28 votes112 views4 answers
Mysql delete database
SQL
7 votes108 views1 answer
Append column sql
SQL
2 votes117 views1 answer
Sql create database
SQL
0 vote122 views1 answer
Sql output select
SQL
11 votes107 views2 answers
Having keyword sql
SQL