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

0 vote300 views1 answer
Components/Fields of Internal Table
SQL
-1 vote276 views1 answer
How to format tables in sqlplus
SQL
0 vote399 views1 answer
How to rename a database in tsql
SQL
0 vote306 views1 answer
Mysql join same table multiple times group by
SQL
0 vote297 views1 answer
Hive batch drop table
SQL
0 vote320 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote353 views2 answers
Fanyi
SQL
0 vote312 views1 answer
Mariadb select limit offset
SQL
0 vote298 views1 answer
Grouping by email domain mysql
SQL
2 votes296 views1 answer
Oracle sql drop table purge
SQL