Multiple Conditional WHERE Conditions
hello,
How does one one write multiple conditional WHERE clauses where any values that are null are not part of the query
Like this but where each one is only part of the where clause if the value is not null
SELECT * FROM table WHERE col1 = ? AND col2 = ? AND col3 = ? AND col4 = ?
Subject
Written By
Posted
Multiple Conditional WHERE Conditions
July 11, 2021 07:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.