Difference: 1. When used for filtering conditions, and means "and", and it must return true when all conditions are true, while or means "or", as long as one condition is true. will return true; 2. The priority of and is greater than or.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
1.and means intersection
2.or means union
3.The priority ratio of and or high
(FirstName='Thomas' OR FirstName='William') AND LastName='Carter' 会得到 lastname 必须为 carter ,firstname 为 thomas 或者 william的人 thomas carter william carter FirstName='Thomas' OR FirstName='William' AND LastName='Carter' 可以得到 william carter 或者 firstname 为ithomas lastname 不一定是 carter的人 比如: thomas carter william carter thomas king
is a matter of the order of or and and. The priority of and is higher than that of or. a or b and c calculate the results of b and c first and then calculate a.
and has priority greater than or.
If parentheses are added, or will be executed first and then and will be executed; without parentheses, and will be executed first and then or, so the query results are different. Example:
Database existing data:
Thomas Carter
William Carter
Thomas King
Execution:
SELECT * FROM Persons WHERE (FirstName='Thomas' OR FirstName='William') AND LastName='Carter'
The result is:
Thomas Carter
William Carter
Execution:
SELECT * FROM Persons WHERE FirstName='Thomas' OR FirstName='William' AND LastName='Carter'
The result is:
Thomas Carter
William Carter
Thomas King
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of What is the difference between and and or in oracle?. For more information, please follow other related articles on the PHP Chinese website!