Toad wrong type

Toad for Oracle & DevOps Toolkit
1

I did

select * from table where column = '1234';
select * from table where column = 1234;

It did not complain about wrong type in either case. It is a number so I expected it to complain about the first one.

2

Oracle does implicit datatype conversion in cases like that where it makes sense. In both cases your 1234 is being treated as a number for the comparison.

1 Like