Bacchas at 18:09, 24 October 2017

2017-10-24T18:09:04Z

← Older revision		Revision as of 18:09, 24 October 2017
Line 10:		Line 10:
	FROM customers		FROM customers
	WHERE state IN('CA','TX');		WHERE state IN('CA','TX');

			SELECT firstname, lastname, state
			FROM customers
			WHERE state NOT IN('CA','TX');

	[[#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 "The IN operator returns records matching one of the values listed in the condition. Oracle 11g syntax requires separating list items with commas, and the entire list must be e..."

2017-10-24T18:07:45Z

Created page with "The IN operator returns records matching one of the values listed in the condition. Oracle 11g syntax requires separating list items with commas, and the entire list must be e..."

New page

The IN operator returns records matching one of the values listed in the condition. Oracle
11g syntax requires separating list items with commas, and the entire list must be
enclosed in parentheses.

SELECT title, pubid
FROM books
WHERE pubid IN (1,2,5);

SELECT firstname, lastname, state
FROM customers
WHERE state IN('CA','TX');

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

IN OPERATOR - Revision history

Bacchas at 18:09, 24 October 2017

Bacchas: Created page with "The IN operator returns records matching one of the values listed in the condition. Oracle 11g syntax requires separating list items with commas, and the entire list must be e..."