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 vote281 views1 answer
Django how to get query result count
SQL
1 vote286 views1 answer
Importance of comment in mysql
SQL
0 vote298 views1 answer
Select * where id = 1,2,3
SQL
9 votes285 views6 answers
Sql add column with default value
SQL
0 vote270 views1 answer
Mysql update sum same table
SQL
2 votes316 views1 answer
Rails execute sql
SQL
0 vote288 views2 answers
Get top 1 row of each group
SQL
5 votes315 views1 answer
Sql table columns
SQL
1 vote304 views1 answer
Customer using hdfc bank sql query
SQL
0 vote281 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL