When you create a filter object to pass to a Select command, the Oracle provider does not accept the following Oracle reserved words as property names: AND, DATE, IN, LIKE, NOT, and OR.
As a result, when you are using a filter string, the string within the expression must be encapsulated inside single quotes as per the SQL language. The following example displays a couple of the reserved words in a filter string and how they should be handled: filterString = ‘AND’=’string’ OR ‘OR’=’some other string’.
In this case, the OR without the quotes is treated as an SQL condition whereas the ‘OR’ inside single quotes is parsed as the value. If you do not encapsulate the expression within single quotes, a parsing error occurs because the parser cannot distinguish between the value and the keyword.