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

1 vote274 views1 answer
Python clean sql string
SQL
0 vote173 views1 answer
Sql select upcoming birthdays
SQL
0 vote184 views1 answer
Update sqlite
SQL
0 vote212 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote126 views1 answer
Procedures and functions in pl/sql
SQL
1 vote161 views2 answers
T sql get foreign key
SQL
0 vote206 views1 answer
Time in sql server
SQL
0 vote169 views1 answer
Mysql procedure between two tables
SQL
0 vote353 views1 answer
Why do we need data structure in sql
SQL
1 vote173 views1 answer
Tsql get beginning of year
SQL