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

0 vote142 views1 answer
Print orcale
SQL
0 vote96 views1 answer
Check sql query executed wp
SQL
0 vote164 views1 answer
Synapse sql table set pk
SQL
3 votes137 views2 answers
Update Query in SQL Server
SQL
5 votes146 views2 answers
Oracle apex debug mode
SQL
0 vote178 views1 answer
Wordpress sql find and replace
SQL
3 votes177 views2 answers
@sqlresultsetmapping
SQL
5 votes176 views1 answer
How to use rank function in sql
SQL
1 vote137 views1 answer
Apex ORA-20999
SQL
0 vote164 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL