Ask you a question, I want to do in the oracle SQL statements in the where clause for a judgment:
If ta orderno is empty, without judging conditions;
If ta orderno is not null, then add ta.621 orderno=tc orderno
Want to add in the where condition how to deal with this?

CodePudding user response:

Ta) orderno=tc) orderno or ta.621 orderno is null

CodePudding user response:

Where ta) orderno is null or ta) orderno=tc orderno

CodePudding user response:

Where ta) orderno=tc) orderno or ta.621 orderno is null