I'm having issues writing a script in oracle. I have a table which contains a text column with type CLOB. Not familiar with this type. I need to extract rows where the text column does not contain N/A, NA, No incentive, and is not null. Is there a way to combine OR and NOT LIKE?
1 <p>This client has an incentive</p>
2 <p>This client has 10 incentives</p>
With the example above, only IDs 1 and 2 would be returned.