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

4 votes281 views3 answers
How to describe a table in sqlite3
SQL
2 votes292 views1 answer
Mysql now format
SQL
0 vote285 views2 answers
How to list all values of a column that start with a letter in sql
SQL
1 vote277 views1 answer
Oracle db create new schema
SQL
1 vote238 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
1 vote273 views1 answer
Mysql history command
SQL
0 vote287 views1 answer
Running query in redshift
SQL
8 votes270 views2 answers
Phpmyadmin password
SQL
0 vote270 views1 answer
Backup a table in sql
SQL
0 vote276 views1 answer
TSQL function split string
SQL