Oracle11g
Oralce11g new features:

At the time of import excel, insert operations, but inserted into the field of virtual fields, no results appear "ORA - 54013: do not allow to perform insert operations" virtual columns, inserted inside a virtual field,

Perform error here:



Pray god to help the younger brother, grateful, online etc.!!!!!!!!!!!

CodePudding user response:

A virtual field, SUBSTR (" A0201B ", 9, 3)

CodePudding user response:

We can only use physical column to insert data

Do not use this: INSERT INTO emp VALUES (10, 1500, 500200);
Use this INSERT INTO t VALUES (empno, sal, comm) (10, 1500, 500);