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 vote141 views1 answer
Display first three characters sql
SQL
0 vote160 views2 answers
Unique key
SQL
2 votes179 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote100 views2 answers
Sql query unique
SQL
0 vote175 views1 answer
Postgresql concat string with separator
SQL
0 vote156 views1 answer
Define a variable in mysql from select
SQL
3 votes143 views1 answer
Sql replace character in string in all records
SQL
4 votes163 views1 answer
Is there any command to change postgres password
SQL
-2 votes139 views1 answer
Use of where in left join in mysql
SQL
1 vote143 views3 answers
Sql select only time from datetime
SQL