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

4 votes242 views1 answer
Oracle change nls_date_format permanently
SQL
6 votes193 views4 answers
Mysql update set
SQL
2 votes181 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote177 views1 answer
Console output pl sql
SQL
3 votes222 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote143 views1 answer
Procedures and functions in pl/sql
SQL
3 votes190 views1 answer
Get current month last date in sql server
SQL
2 votes255 views2 answers
Null column to 0 in mysql
SQL
0 vote270 views1 answer
Run docker container with database as rds metabase
SQL
0 vote184 views1 answer
Mariadb current date plus 1 day
SQL