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 votes215 views2 answers
Mysql select database
SQL
0 vote252 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote191 views1 answer
Array aggre distinct postgres
SQL
0 vote9.7K views1 answer
Postgresql delete type
SQL
2 votes183 views1 answer
Ssh mysql port forwarding
SQL
0 vote199 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote198 views1 answer
Tsql find foreign key references
SQL
0 vote214 views1 answer
Pl sql turn off variable substitution
SQL
5 votes187 views1 answer
Update sql user password
SQL
0 vote210 views1 answer
Sql order by except one row
SQL