Oracle calculated 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 votes241 views1 answer
Alter table default value mysql
SQL
11 votes287 views2 answers
Insert current date sql
SQL
0 vote290 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote290 views1 answer
Oracle undo usage per session
SQL
0 vote317 views1 answer
Create table using the clause with as
SQL
0 vote287 views1 answer
Close sql query vb.net
SQL
0 vote277 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
1 vote286 views1 answer
Mysql drop key
SQL
6 votes270 views2 answers
Mysql check auto increment value
SQL
4 votes284 views3 answers
Check if two date ranges overlap sql server
SQL