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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s