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

1 vote169 views1 answer
Select dba users oracle
SQL
1 vote187 views1 answer
Sql select where id not exists in another table
SQL
0 vote189 views1 answer
Mssql disable foreign key constraint
SQL
0 vote320 views1 answer
Generate a random otp in sql server
SQL
0 vote186 views4 answers
How to connect form to database
SQL
5 votes183 views1 answer
Oracle ORA-00054 origin
SQL
-1 vote181 views1 answer
How to switch user in mysql
SQL
3 votes188 views1 answer
Stpop start psql server
SQL
0 vote223 views2 answers
Drop tables from local table database postgres
SQL
1 vote180 views3 answers
Get all tables postgres
SQL