Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE cars_table  ( year, make, model ) AS
WITH years ( year ) AS (
  SELECT 2011 FROM DUAL UNION ALL
  SELECT 2015 FROM DUAL UNION ALL
  SELECT 2017 FROM DUAL
),
makes ( make ) AS (
  SELECT 'Honda' FROM DUAL UNION ALL
  SELECT 'Toyota' FROM DUAL
),
models ( model ) AS (
  SELECT 'Corolla' FROM DUAL UNION ALL
  SELECT 'Camry' FROM DUAL UNION ALL
  SELECT 'Civic' FROM DUAL
)
SELECT year, make, model
FROM   years CROSS JOIN makes CROSS JOIN models;
18 rows affected

SELECT *
FROM   cars_table
WHERE (year, make, model) IN (
        (2015,'Toyota','Camry'),
        (2017,'Honda','Corolla'),
        (2011,'Honda','Civic')
      )


YEAR
MAKE
MODEL


2011
Honda
Civic

2017
Honda
Corolla

2015
Toyota
Camry


select *
from   cars_table
where  year in (2015,2011,2017)
and    make in ('Toyota','Honda')
and    model in ('Camry','Corolla','Civic')


YEAR
MAKE
MODEL


2011
Honda
Corolla

2011
Honda
Camry

2011
Honda
Civic

2015
Honda
Corolla

2015
Honda
Camry

2015
Honda
Civic

2017
Honda
Corolla

2017
Honda
Camry

2017
Honda
Civic

2011
Toyota
Corolla

2011
Toyota
Camry

2011
Toyota
Civic

2015
Toyota
Corolla

2015
Toyota
Camry

2015
Toyota
Civic

2017
Toyota
Corolla

2017
Toyota
Camry

2017
Toyota
Civic

YEAR	MAKE	MODEL
2011	Honda	Corolla
2011	Honda	Camry
2011	Honda	Civic
2015	Honda	Corolla
2015	Honda	Camry
2015	Honda	Civic
2017	Honda	Corolla
2017	Honda	Camry
2017	Honda	Civic
2011	Toyota	Corolla
2011	Toyota	Camry
2011	Toyota	Civic
2015	Toyota	Corolla
2015	Toyota	Camry
2015	Toyota	Civic
2017	Toyota	Corolla
2017	Toyota	Camry
2017	Toyota	Civic