query to write multiple matched strings in single query by using RegExp

147 views Asked by At

I wanted to write a query to not match with the mentioned strings Requirement as below

SELECT *
FROM fnd_lookups_all
WHERE lookup_type = 'SELECTION_TAX'
      AND source_value = p_input_source
      AND attribute1 = tax_aut_num
      AND attribute2 = -p_remi_code
      AND attribute6 = TO_CHAR ('RBC')
      AND lookup_code NOT LIKE '%POF%' OR NOT LIKE '%AT%';

How should I improve this query?

0

There are 0 answers