Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Questions about SQL ''='' Qracle and mysql behavior inconsistencies

User_4PJMKSep 8 2022

The SQL: select * from <TABLE> where ''=''
In oracle database this sql unable to query any data, but in mysql can query all the data.

The SQL: select * from <TABLE> where '' is null
In mysql this sql unable to query any data, but in oracle database can query all the data.
What did I do wrong?

This post has been answered by L. Fernigrini on Sep 8 2022

Jump to Answer

Added on Sep 8 2022

#general-database-discussions

9 comments

212 views