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

-2 votes372 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote409 views1 answer
Drop view in mysql
SQL
0 vote338 views1 answer
Mysql local password denied
SQL
4 votes353 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
10 votes352 views6 answers
Mysql delete duplicates
SQL
0 vote342 views1 answer
Pip install mysqlclient error
SQL
10 votes337 views4 answers
Primary key sql
SQL
4 votes378 views1 answer
Data types in sql
SQL
2 votes378 views1 answer
Sql get the name of user pc
SQL
0 vote349 views1 answer
Hibernate xml property MySQL url, username and password
SQL