All errors › ORA errors
ORA-00913: Too many values
What it means
The number of values is larger than the number of target columns: INSERT ... VALUES / INSERT ... SELECT with more expressions than columns, or a subquery that returns more columns than the comparison expects.
How to fix it
List the target columns explicitly in INSERT (INSERT INTO t (a, b) VALUES ...) and count both sides. For subqueries compare the column count on both sides of IN / = .
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.