Oracle generated 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 vote201 views1 answer
Mysql show schema
SQL
11 votes177 views2 answers
Sql rank
SQL
0 vote172 views1 answer
Insert into Select * - NAYCode.com
SQL
10 votes173 views6 answers
Sql between
SQL
0 vote171 views1 answer
Oracle execute immediate quotes
SQL
0 vote176 views1 answer
Sql server pivot rows to columns
SQL
1 vote160 views3 answers
Sql union
SQL
4 votes154 views1 answer
Sql delete where in select
SQL
8 votes179 views1 answer
Oracle tablespace datafile max size
SQL
20 votes198 views4 answers
How to find average in sql
SQL