You are correct, the negation operator works properly only when applied to atomic predicates. Consequently, to avoid wrong query results when negating complex expression, Arbori flags syntax error.
What you are looking in your example is the minus operator:
WhenOthesrWithoutRaise: AllOtherClauses - ProperlyFormedOtherClauses;
I'm assuming you and ThatJeffSmith realize:
Since we can "identify a specific code pattern" within our worksheet and then highlight it,
We now want to "identify a specific code pattern" within our Database and then (manually) fix it.
Or ... at least... that's what I desire.
Vadim Tropashko-Oracle wrote:
I don't understand your comment.
I would like to have the ability to generate a report that shows how many occurrence of each rule is found within each DB Object that are owned by the Schemas I have selected.
This will give me some information that I can use to decide where I should concentrate "code improvement" efforts/resources.
I'm assuming this would be a "Feature Request"