Search notes:

ORA-00947: not enough values

create table tq84_tab (num number, txt varchar2(22), dt date);
insert into  tq84_tab values (42, 'hello world');

Insert statement with missing parantheses after the VALUES keyword:

insert into  tq84_tab (num, txt) values 42, 'hello world'

If only one column were specified, the statement would throw ORA-03001: unimplemented feature.

Cleaning up:

drop   table tq84_tab;

See also