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

1 vote123 views1 answer
Sql row having max
SQL
0 vote106 views1 answer
Groupby sort sql hive
SQL
0 vote73 views1 answer
Oracle sql replace string in clob
SQL
0 vote113 views1 answer
Get statis values sql
SQL
0 vote121 views1 answer
Count in sql and diff
SQL
0 vote124 views1 answer
How to move a column to different spot mysql
SQL
11 votes102 views2 answers
Having clause
SQL
0 vote104 views1 answer
Show database not empty tables postgres
SQL
3 votes103 views2 answers
Sql paging query
SQL
0 vote105 views1 answer
Console output pl sql
SQL