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
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;