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 vote320 views1 answer
T-sql delete view if exists
SQL
0 vote310 views1 answer
Sql express database size limit
SQL
7 votes300 views2 answers
Oracle sql drop index
SQL
0 vote324 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote284 views1 answer
Connect postgresql using a connection string
SQL
2 votes297 views2 answers
How to check database username and password in postgresql
SQL
0 vote291 views1 answer
How to add more columns to a table in mysql
SQL
2 votes285 views1 answer
Sql server conection string
SQL
0 vote304 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote289 views1 answer
Rename view mysql
SQL