Case the when question, what's the problem with this query, does not return data, please are you expert help answer

CodePudding user response:

0002 the corresponding 024 is empty, 0026 corresponding 029 is empty, the other end to end

CodePudding user response:

End to end forgot to copy, leave the 024 and 029 data, I think if it is 0002 and he took 024 values, this line of thought, right?

CodePudding user response:

Well, is like this

CodePudding user response:

Oracle database function is very powerful, in addition to the use case when, you can also use oracle database provides the function of decode, you written above can be changed to the following:
Select the decode (t1) RULE_CODE, 0002, t1. NODENAME024, 0026, t1. NODENAME029) from t1