I have Crores of Data in Oracle in string format. I want to run a rule engine on the messages for validations. For eg. Some strings can be more then set limit. Check the content of each string and validate few things in it.

Question

I have Crores of Data in Oracle in string format(in each row). I want to run a rules on these strings(rows) for validations.

For eg.

1. Some strings can be more then set limit.
2. Check the content of each string and validate few things in it.
3. Some might contain special characters or links in them.
4. Seggregate the strings in groups of similar format.

At the end i need to create a report of the rules outcome.

Which service can i use to solve the above problem statement.