In-condition with parameterized expression list
Posted: Wed 27 Nov 2019 07:55
In Oracle it's possible to write queries like this one (see https://docs.oracle.com/cd/B19306_01/se ... m#i1033664):
Is it possible to programmatically write a similar query with the expression list being a parameter (for example a list of tuples?).
Code: Select all
SELECT * FROM employees
WHERE (first_name, last_name, email) IN
(('Guy', 'Himuro', 'GHIMURO'),('Karen', 'Colmenares', 'KCOLMENA'))