ORA-00984: column not allowed here
ORA-06512: at "SS_REPO.PKG_SS_LOAD_ALL_TRANS", line 539
ORA-06512: at "SS_REPO.PKG_SS_LOAD_ALL_TRANS", line 42
ORA-06512: at line 6

  create table t1 ( c1 varchar2(100), c2 varchar2(100), c3 varchar2(100))
  
  insert into t1 a values ('ashok','kumar',CONCAT(c1,c2))

insert into t1 a values ('ashok','kumar',CONCAT('ashok', 'kumar'))

create table t1
( c1 varchar2(100), 
  c2 varchar2(100), 
  c3 varchar2(200) generated always as (concat(c1, c2)) virtual
);
   
insert into t1 (c1, c2) values ('ashok','kumar');

SQL> create table t1
  2  ( c1 number,
  3    c2 number,
  4     c3 number generated always as (c1 / c2) virtual
  5  );

Table created.

SQL> insert into t1(c1,c2) values(1,0);

1 row created.

SQL> select c1,c2 from t1;

        C1         C2
---------- ----------
         1          0

SQL> select * from t1;
select * from t1
    *
ERROR at line 1:
ORA-01476: divisor is equal to zero