4
In Oracle there are several operators to make "different" comparisons, such as:
<>
¬=
!=
^=
Example:
Select * from tabel where nomeTabela <> 's';
Select * from tabel where nomeTabela != 's';
Select * from tabel where nomeTabela ^= 's';
Select * from tabel where nomeTabela ¬= 's';
All will return the same result, said I wonder if there is any difference in performance, version between them? If not, is expected to discontinue for any of them?
That’s not just in
Oracle
, at least some of those operators also operate in the same way inMySQL
, then I imagine it’s something of its ownSQL
.– Roberto de Campos
I didn’t know, I’ve been living more in the oracle
– Luiz Santos