Hi Katie, great article, thx for taking the time to share it.
Concerning the <> ALL syntax, in Oracle, it is possible to use it when matching multiple columns without having to concatenate them. It's done using sets :
... WHERE (COL_A1, COL_A2, COL_A3) <> ALL (SELECT COL_B1, COL_B2, COL_B3 FROM B)
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hi Katie, great article, thx for taking the time to share it.
Concerning the <> ALL syntax, in Oracle, it is possible to use it when matching multiple columns without having to concatenate them. It's done using sets :
... WHERE (COL_A1, COL_A2, COL_A3) <> ALL (SELECT COL_B1, COL_B2, COL_B3 FROM B)