Oracle case cannot have the equal sign and the and how to solve-CodePudding

Oracle case cannot have the equal sign and the and how to solve

CodePudding user response:

What do you want?

To write value after then, it is not written expression, expression moved to behind the when,

CodePudding user response:

reference 1st floor selling fruit net reply:

what do you want?

After then to write value, cannot write expression, expression moved to behind the when,

splicing left behind the join condition

CodePudding user response:

Behind the conditions on the when, change,

CodePudding user response:

references 4 floor selling fruit net reply:

conditions behind the when, and modify the,

. Inside the parentheses are the result of the I will trigger. In mysql is wrote by oracle is dizzy...

CodePudding user response:

reference 5 floor weixin_44713088 reply:

Quote: refer to 4th floor selling fruit net reply:

Conditions behind the when, and revise the,

. Inside the parentheses are the result of the I will trigger. In mysql is wrote by oracle is dizzy...

The same applies to the oracle

CodePudding user response:

refer to 6th floor lhdz_bj response:

Quote: refer to the fifth floor weixin_44713088 reply:

Quote: refer to 4th floor selling fruit net reply:

Conditions behind the when, and revise the,

. Inside the parentheses are the result of the I will trigger. In mysql is wrote by oracle is dizzy...

Oracle,

error ah.. I will according to the condition judgment, left the join on the back of the conditions

CodePudding user response:

refer to 7th floor weixin_44713088 response:

Quote: refer to the sixth floor lhdz_bj response:

Quote: refer to the fifth floor weixin_44713088 reply:

Quote: refer to 4th floor selling fruit net reply:

Conditions behind the when, and revise the,

. Inside the parentheses are the result of the I will trigger. In mysql is wrote by oracle is dizzy...

Oracle,

error ah.. I will according to the condition judgment, left the join conditions on the back of the

That does not support conditions in the use case, to:
The if... Then
SQL;
The else
SQL;
end if;
This kind of?

CodePudding user response:

Then, the return value is written in this kind of demand can be realized with logical expression

And ((([[in the when condition]]) and ([the join condition in the [then]])) or (([[in the other the when condition]]) and ([[other connection condition]])))

Or change the logic written
A.a aa=case when... end