Oracle calculated 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 vote335 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
3 votes352 views2 answers
Brew restart mysql
SQL
0 vote378 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote345 views1 answer
How to create an SQL save method in ruby
SQL
32 votes355 views6 answers
Insert into values select
SQL
0 vote370 views1 answer
How to list function in psql
SQL
0 vote379 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
1 vote340 views2 answers
How to check username in mysql command line
SQL
0 vote336 views1 answer
T-sql check if data exists
SQL
0 vote324 views2 answers
Sql select inside select
SQL