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 vote231 views1 answer
Mysql select field if condition
SQL
0 vote136 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote170 views1 answer
Reindexing all tables sql server
SQL
12 votes148 views5 answers
Sql primary key
SQL
0 vote140 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes184 views2 answers
Mysql date range
SQL
10 votes147 views1 answer
All_dependencies
SQL
3 votes137 views1 answer
Get current month last date in sql server
SQL
0 vote143 views1 answer
Mysqli_connect using prepare statement
SQL
14 votes129 views3 answers
Trim sql
SQL