Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table                
employee( eno     integer
        , ename   varchar2(50)
        , base    number(8,2)
        , da      generated always  as (base * 0.05) virtual
        , gross   generated always  as (base * 1.05) virtual
        ) ;
-- now   OOPS
insert into employee (eno, ename, base,da, gross)
 select  1,'George',200,.05,210 from dual union all
 select  2,'Pam',100,.05,105    from dual; 
  
ORA-54013: INSERT operation disallowed on virtual columns

-- but  
insert into employee (eno, ename, base)
 select  1,'George',200  from dual union all
 select  2,'Pam',100     from dual;
2 rows affected

select * from employee;


ENO
ENAME
BASE
DA
GROSS


1
George
200
10
210

2
Pam
100
5
105


update employee
   set base = 300
     , da   = .05
     , gross = 315
 where eno = 2; 
ORA-54017: UPDATE operation disallowed on virtual columns

update employee
   set base = 300
 where eno = 2;
1 rows affected

select * from employee;


ENO
ENAME
BASE
DA
GROSS


1
George
200
10
210

2
Pam
300
15
315