Search notes:

ORA-00913: too many values

create table tq84_tab (num number, txt varchar2(10), dt date);
insert in to tq84_tab values (1, 42, sysdate, 'xyz');
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;

See also

ORA-00947: not enough values
ORA-01789: query block has incorrect number of result columns
Other Oracle error messages

Index