Skip to Main Content

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
Comments
Post Details
Added on Sep 8 2022
9 comments
207 views