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

7 votes161 views3 answers
Sql server reset auto increment
SQL
3 votes134 views1 answer
Sql select all
SQL
0 vote166 views1 answer
How convert into in in sql query
SQL
0 vote148 views1 answer
Initcap in mysql
SQL
0 vote118 views1 answer
Oracle sysdba connect as another user
SQL
1 vote146 views2 answers
Mysql extract month
SQL
2 votes138 views1 answer
How to add where command in update comand with joins
SQL
-1 vote136 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote207 views1 answer
Sql int vs integer
SQL
0 vote148 views1 answer
Primary key multiple colums
SQL