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 vote179 views1 answer
Increase existing date in sql oracle
SQL
11 votes186 views2 answers
Mysql set safe mode off
SQL
35 votes175 views6 answers
Postgres
SQL
18 votes175 views6 answers
Mysql create table
SQL
0 vote197 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote187 views1 answer
Sql filter rows with condition
SQL
0 vote133 views1 answer
FindAllBy
SQL
8 votes127 views1 answer
Similarities between ddl and dml
SQL
0 vote180 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
2 votes168 views1 answer
How to select first row of database sql
SQL