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 vote155 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
2 votes167 views2 answers
Calculate percentage in sql
SQL
-2 votes199 views1 answer
Trunc in sql
SQL
0 vote98 views1 answer
Oracle list all stored procedures
SQL
50 votes217 views4 answers
Sql alter type of column
SQL
21 votes142 views1 answer
SQL cheat sheet pdf
SQL
1 vote189 views1 answer
Postgresql append array
SQL
0 vote144 views1 answer
How to list function in psql
SQL
5 votes142 views1 answer
Oracle ORA-00054 origin
SQL
0 vote133 views1 answer
How to stop all connections to a psql 12 database?
SQL