SQL & PL/SQL

I have a sql that I'm comparing values ​​inside an "in" clause and I should only return if they all exist. Example:

select *
from test
where field1 in ('AAA', 'BBB', ''CCC', 'DDD');

In the table "test" field "field1" I do not have the value ''CCC'. So I shouldn't bring any results.

select *
from test
where field1 in ('AAA', 'BBB', 'DDD');

In the table "test" field "field1" I have 'AAA', 'BBB', 'DDD'. So I must bring the 3 results.