-- https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/Multiset-Conditions.html
SELECT customer_id, cust_address_ntab
  FROM customers_demo
  WHERE cust_address_typ('8768 N State Rd 37', 47404, 
                         'Bloomington', 'IN', 'US')
  MEMBER OF cust_address_ntab
  ORDER BY customer_id;