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

5 votes376 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote338 views1 answer
Sql query to check if column contains alphabets
SQL
1 vote394 views1 answer
Delete dublicate rows sql
SQL
0 vote336 views3 answers
Drop multiple columns in sql
SQL
0 vote373 views1 answer
C# mysql data reader from two tables
SQL
0 vote333 views1 answer
Convert sql server guid to varbinary
SQL
0 vote375 views1 answer
Sql sum show 0 result
SQL
0 vote342 views1 answer
Addition of 2 column value in mysql
SQL
0 vote360 views1 answer
Full outer join in mariadb mysql
SQL
0 vote364 views1 answer
T-sql email validation
SQL