PL/SQL ANY

The PL/SQL ANY is used like comparison condition, must be preceded by =, !=, >, < , <=, >= and followed by a list or subquery.

ANY example

 
SELECT * FROM course WHERE price = ANY (10,20);

Output

COURSE_ID	NAME	DESCRIPTION	DURATION	PRICE
1	SQL 1	SQL course for beginners	1 week	10
3	HTML5	Learn HTML 5	1 week	10
5	CSS	Learn CSS	2 week	20

ANY example

 
SELECT s.student_id, s.first_name, s.last_name, s.city 
FROM students s 
WHERE s.student_id = ANY (SELECT o.student_id FROM orders o)
ORDER BY s.student_id;

Output

STUDENT_ID	FIRST_NAME	LAST_NAME	CITY
4	Emily	PETERSON	Phoenix
5	David	DAWSON	Seattle
6	Gabriel	LEWIS	Boston
7	Natalie	MARTIN	Baltimore

↑