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

3 votes235 views2 answers
How to View column names of a table in SQL
SQL
0 vote199 views1 answer
Implicit inner join table alias
SQL
0 vote211 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote198 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote197 views1 answer
Uncheck constraints and delete from table
SQL
0 vote200 views1 answer
Pagination with row_number
SQL
2 votes215 views1 answer
Sql skip the first row
SQL
0 vote210 views1 answer
Sql select sum group by id laravel join
SQL
0 vote191 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote198 views1 answer
Oracle create program if no exists
SQL