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

1 vote305 views2 answers
Mysql current user
SQL
-1 vote309 views1 answer
Add bool column in sql
SQL
2 votes307 views1 answer
Postgresql transaction
SQL
6 votes320 views2 answers
Where clause in sql
SQL
0 vote334 views1 answer
Will graphql replace sql
SQL
11 votes319 views1 answer
Mysql order by two columns priority
SQL
21 votes352 views6 answers
Update sql
SQL
0 vote308 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote343 views1 answer
Get only one row in mysql
SQL
7 votes313 views1 answer
Sql server convert string to date
SQL