select * from dual where null != 'X' no rows returnedA null can never equal a value, and hence cannot be determined to be disimilar to another value. False is the expected condition.
Turns out when using it as what appears to be the
So if you want to display something based on a field that may have a value you don’t want, eg:
This will display the component if P10_NULL is anything but "yuck", including a null value.
In my business case, there was an occasional value of "D" that I need to hide things for.
Instead of using (slower) PL/SQL expression
nvl(:P42_CAT,'x') != 'D'
or SQL expression (anything but = D)
As Kim suggests, our brain is seeing something SQL-ish, when really it's a low code translation that probably nails most scenarios - and maybe it would be better re-worded slightly as "not equals"
Our low code alternative is not only faster, but simpler. It turns it into just another if statement, as opposed to a snippet of PL/SQL that's interpreted on the fly, which is why dozens of global page conditions using PL/SQL expressions will slow your application.
Tom Kyte's mantra was to aim to reduce to just a single SQL statement (or no SQL at all).
Perhaps APEX developers should advocate for declarative attributes where possible, only then maybe try an expression or query.