When executing queries in sql developer there is one error that fails to inform you where it occured.
if you try following sql
select 1 from dual
where 1 = 'A'
you get an invalid number error but it does not specify where it is occuring.
Not handy when trying to debug a plus 200 lined sql code.
Other errors do report the line number. so why is this one different?
even in sqlplus this works
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select 1 from dual
2 where 1 = 'A';
where 1 = 'A'
*
ERROR at line 2:
ORA-01722: invalid number