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

-1 vote169 views1 answer
Condition in orderby mysql
SQL
0 vote187 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote166 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote177 views1 answer
Sql doesn't contain
SQL
0 vote174 views1 answer
Select * from mysql.proc
SQL
0 vote168 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote165 views1 answer
Right outer vs left outer join
SQL
0 vote171 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote194 views1 answer
Query to insert image
SQL
2 votes193 views1 answer
Find column in all stored procedures sql server
SQL