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

10 votes335 views1 answer
User_dependencies
SQL
0 vote355 views1 answer
SQL-Arten
SQL
0 vote329 views1 answer
Start and stop mysql
SQL
0 vote366 views2 answers
Connect to mysql server mac terminal
SQL
1 vote317 views1 answer
Real world example of nosql
SQL
0 vote335 views1 answer
Select nth row in mysql
SQL
-1 vote330 views1 answer
Mysql change database charset and collation
SQL
0 vote348 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote311 views1 answer
Oracle right characters
SQL
1 vote347 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL