ORA-00913: too many values

This is a silly mistake. Let me tell you what. I am inserting some values to a table. see the following query.

insert into mytable (col1, col2) values ('tanya', 'mega', 'harish')
ORA-00913: too many values

so you got it :) we can identify this easily when updating less number of variables, I was updating 90+ columns, and I have given some extra values. what to do.. remove the extra..!

http://www.techonthenet.com/oracle/errors/ora00913.php

Comments are closed.