Query returns NULL - Oracle
Your syntax is wrong you need  parenthesis around the value(s)
Please remember not to post Images for data, queries and errors


CREATE TABLE table1 (
  
  id VARCHAR(50)
);




INSERT INTO table1
VALUES
  ('PL4418.01301006-H01-D-03013O322241');




INSERT INTO table1
VALUES
  ( '04l801301006-I401•0013ccO27I0');




  INSERT INTO table1
VALUES
  ( 'P104I8.013016-H0l-D0l3c60O22l1');




  INSERT INTO table1
VALUES
  ( 'P104I8013016-I40l-D013c0c0224V');




  INSERT INTO table1
VALUES
  ( 'P10418-013016-HO1-D-010X2141');




  INSERT INTO table1
VALUES
  ('PL-0418-013016-H01-D-0132241');




  INSERT INTO table1
VALUES
  ( 'PL.5410.01301006-H0l-D.0201300022'); 




SELECT * FROM table1 WHERE id IN ('P104I8013016-I40l-D013c0c0224V');


| ID                             |
| :----------------------------- |
| P104I8013016-I40l-D013c0c0224V |


db&lt;&gt;fiddle here