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

4 votes245 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote293 views1 answer
Sql server system messeges
SQL
0 vote211 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote194 views1 answer
How to output a different column name in mysql
SQL
7 votes220 views5 answers
Max 3 salary in sql
SQL
0 vote160 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote319 views1 answer
SQL query to verify the size of the table
SQL
0 vote207 views1 answer
Oracle gather table statistics
SQL
0 vote207 views4 answers
Sql rownum
SQL
10 votes154 views2 answers
Django mysql
SQL