Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Better alternative for not like operator
Summary:
Better alternative for not like operator
Content (please ensure you mask any confidential information):
Hello ,
I am trying to exclude certain checklist names from the LOVs in the data model.
I have beenin using the following logic
select name, checklist_id
from PER_CHECKLISTS_VL
where name not like '%Pulse Survey%' and name not like '%merger pulse survey%' and name not like '% associate experience survey%' and name not like '% Engagement Survey%' .
But I feel this is not the best way and I could make this opmitimised. Also, I notice that this is case sentive. Example: %merger survey% is treated differently from %Merger Survey%
Tagged:
0