Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tab (
     id_tab integer not null,
     val1 integer,
     val2 integer,
     val3 integer,
     val4 integer,
     val5 integer,
     val6 integer,
     val7 integer,
     val8 integer,
     val9 integer,
     CONSTRAINT tab_pk PRIMARY KEY (id_tab)
  );
  
  create index val1_index on tab (val1);
  create index val2_index on tab (val2);
  create index val3_index on tab (val3);
  create index val4_index on tab (val4);
  create index val5_index on tab (val5);
  create index val6_index on tab (val6);
  create index val7_index on tab (val7);
  create index val8_index on tab (val8);
  create index val9_index on tab (val9);
  create procedure test1 as
  begin
    for x in 1..10000
    loop
      insert into tab(id_tab, val1, val2, val3, val4, val5, val6, val7, val8, val9)
      values ((select nvl(max(id_tab), 0) + 1 from tab), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)),
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)), 
              decode(round(dbms_random.value(0,2)), 1, null, dbms_random.value(1,9)));
    end loop;
  end;
  /
BEGIN
test1;
END;
/
1 rows affected

insert into tab (id_tab, val1, val2, val3, val4, val5, val6, val7, val8, val9) 
values(-1, 3, 1, null, 5, 2, 1, 9, null, 1);
1 rows affected

SELECT * FROM tab
where 
(decode(val1, 3, 1) = 1) and 
(decode(val2, 1, 1) = 1) and 
(decode(val3, null, 1) = 1) and
(decode(val4, 5, 1) = 1) and
(decode(val5, 2, 1) = 1) and
(decode(val6, 1, 1) = 1) and
(decode(val7, 9, 1) = 1) and
(decode(val8, null, 1) = 1) and
(decode(val9, 1, 1) = 1)


ID_TAB
VAL1
VAL2
VAL3
VAL4
VAL5
VAL6
VAL7
VAL8
VAL9


-1
3
1
null
5
2
1
9
null
1