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 vote280 views1 answer
MySQL - How to find word with the most similar beginning
SQL
-1 vote186 views1 answer
Plsql while
SQL
0 vote198 views1 answer
Version and edition of SQL Server Database Engine
SQL
6 votes214 views2 answers
Sql display max value
SQL
16 votes221 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote210 views1 answer
Set a default value for a column in sqlite
SQL
0 vote206 views3 answers
Postgres trim string
SQL
2 votes207 views1 answer
Add default sql server
SQL
0 vote195 views2 answers
Delete query sql server
SQL
21 votes202 views1 answer
SQL cheat sheet pdf
SQL