Oracle PL/SQL - Use the ALL operator in a WHERE clause to compare a value with all of the values in a list

 Use the ALL operator in a WHERE clause to compare a value with all of the values in a list

SELECT * FROM TEMPEMP

SELECT * FROM TEMPEMP WHERE ID > ALL(21,22,23)

RESULT: