Search notes:

ORA-00913: too many values

create table tq84_tab (num number, txt varchar2(10), dt date);

The following statement throws ** because more columns are selected than the destination table has:

insert into tq84_tab values (1, 42, sysdate, 'xyz');

This statement runs successfully:

insert into tq84_tabx values (1, 42, sysdate);

Cleaning up:

drop   table tq84_tab;

Invisible columns

When inserting a value into a invisible column, the column name must be stated

create table tq84_ora_00913 (
   vis   integer,
   hid   varchar2(20) invisible
);
 
insert into tq84_ora_00913 values (42, 'hello world');
--
---ORA-00913: too many values
 
insert into tq84_ora_00913 (vis, hid) values (42, 'hello world');
--
---1 row inserted.

drop   table tq84_ora_00913;

ORA-00913: too many values

Invisible columns

See also