Stepwise-Lab

ORA-01722: Invalid number

A character value that is not a number was converted to NUMBER: usually implicitly, when a string is compared with a number column, used in arithmetic, or in NVL/DECODE with a number first argument.

On the exam

This error belongs to the topic Conversion and conditional of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors