LOGICAL Operators - Revision history

Bacchas at 20:17, 24 October 2017

2017-10-24T20:17:34Z

← Older revision		Revision as of 20:17, 24 October 2017
Line 19:		Line 19:
	* Comparison operators (5, 4, ¼, LIKE, and so forth) are solved next.		* Comparison operators (5, 4, ¼, LIKE, and so forth) are solved next.
	* Logical operators have a lower precedence and are evaluated last—in the order NOT, AND, and OR.		* Logical operators have a lower precedence and are evaluated last—in the order NOT, AND, and OR.
			Logical operators are always evaluated in the order NOT, AND, and OR. Parentheses
			can be used to override the evaluation order.

	SELECT *		SELECT *

Bacchas at 19:55, 24 October 2017

2017-10-24T19:55:02Z

← Older revision		Revision as of 19:55, 24 October 2017
Line 19:		Line 19:
	* Comparison operators (5, 4, ¼, LIKE, and so forth) are solved next.		* Comparison operators (5, 4, ¼, LIKE, and so forth) are solved next.
	* Logical operators have a lower precedence and are evaluated last—in the order NOT, AND, and OR.		* Logical operators have a lower precedence and are evaluated last—in the order NOT, AND, and OR.

			SELECT *
			FROM books
			WHERE (category = 'FAMILY LIFE'
			OR pubid=4)
			AND cost > 15;


	[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 19:48, 24 October 2017

2017-10-24T19:48:46Z

← Older revision		Revision as of 19:48, 24 October 2017
Line 15:		Line 15:
	FROM books		FROM books
	WHERE pubid = 3 OR category = 'COMPUTER'		WHERE pubid = 3 OR category = 'COMPUTER'
			=== Order of Logical Operators ===
			* Arithmetic operations are solved first.
			* Comparison operators (5, 4, ¼, LIKE, and so forth) are solved next.
			* Logical operators have a lower precedence and are evaluated last—in the order NOT, AND, and OR.


	[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: Created page with "At times, you need to search for records based on two or more conditions. In these situations, you can use logical operators to combine search conditions. The logical operator..."

2017-10-24T19:46:23Z

Created page with "At times, you need to search for records based on two or more conditions. In these situations, you can use logical operators to combine search conditions. The logical operator..."

New page

At times, you need to search for records based on two or more conditions. In these
situations, you can use logical operators to combine search conditions. The logical operators
AND and OR are commonly used for this purpose. (The NOT operator mentioned in
Table 8-2 is also a logical operator in Oracle 11g, but it’s used to reverse the meaning of
search conditions rather than combine them.) Keep in mind that when a query executes,
records can be filtered with WHERE clause conditions. In other words, each record in the
table is compared with the stated condition. If the condition is TRUE when compared with
a record, the record is included in the results.

SELECT title, pubid, category
FROM books
WHERE pubid = 3 AND category = 'COMPUTER'

SELECT title, pubid, category
FROM books
WHERE pubid = 3 OR category = 'COMPUTER'

[[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]