Oracle generated 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 vote181 views1 answer
Import sql inside hide sql
SQL
5 votes167 views1 answer
How to check nls format in oracle
SQL
8 votes127 views1 answer
Similarities between ddl and dml
SQL
0 vote217 views2 answers
Remove mysql workbench ubuntu
SQL
4 votes168 views1 answer
Mysql timestamp in laravel migration
SQL
3 votes180 views2 answers
See mysql users ubuntu
SQL
0 vote183 views1 answer
Load data infile mariadb slow
SQL
2 votes168 views1 answer
Sql count having
SQL
0 vote183 views1 answer
Authentication modes in sql server
SQL
0 vote186 views1 answer
Oracle chain step succeeded
SQL