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

2 votes189 views1 answer
Sql create database
SQL
4 votes211 views6 answers
List all tables in postgres
SQL
0 vote243 views1 answer
Download sql file of countries names
SQL
0 vote180 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
1 vote176 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote210 views1 answer
How much space does sql server take per row
SQL
0 vote203 views1 answer
Kill a pid redshift
SQL
1 vote194 views1 answer
Increasing font and zooming in mysql workbench
SQL
1 vote202 views1 answer
Pagination sql
SQL
31 votes199 views3 answers
SQL Server change column data type
SQL