Oracle virtual 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 vote216 views1 answer
Kill a pid redshift
SQL
3 votes206 views2 answers
Brew start mysql
SQL
0 vote205 views1 answer
Do you know sql
SQL
0 vote209 views1 answer
Output table plsql
SQL
3 votes229 views2 answers
Oracle drop sequence
SQL
5 votes206 views2 answers
Add column postgres with default value
SQL
2 votes216 views1 answer
Guid to string sql
SQL
7 votes236 views5 answers
Max 3 salary in sql
SQL
0 vote237 views2 answers
Start mysql server using docker
SQL
1 vote193 views1 answer
Postgresql convert text to float
SQL