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

6 votes138 views5 answers
Mysql get last insert id
SQL
0 vote131 views1 answer
Sql right characters
SQL
8 votes142 views1 answer
Sql remove leading spaces
SQL
0 vote146 views1 answer
Get the previous column of a table in mysql
SQL
0 vote131 views1 answer
How to to get current date and time in sql
SQL
0 vote132 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote138 views1 answer
Not between mysql
SQL
0 vote139 views1 answer
Sql find leading space
SQL
7 votes139 views1 answer
Minecraft forge server host
SQL
0 vote159 views2 answers
Unique key
SQL