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

0 vote291 views1 answer
Order by number of character in sql
SQL
1 vote300 views1 answer
Postgresql contains
SQL
1 vote313 views1 answer
Postgresql export output table as a csv
SQL
4 votes338 views1 answer
Rename stored procedure in sql server
SQL
0 vote335 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
2 votes342 views2 answers
Create temporary table in mysql
SQL
0 vote318 views1 answer
Mysql Selected All Duplicate Rows
SQL
16 votes349 views1 answer
Sqlserver add column to table
SQL
0 vote318 views1 answer
Oracle locked objects
SQL
0 vote305 views1 answer
<sql:datasource var="Snapsho"
SQL