Does any one know, why the below mentioned SQL does not work in specified Syntax, but works fine if mentioned in a different way.
I wanted to know the tables which have been cached in the Database, the SQL written is :-
WHERE owner NOT IN ('SYS','SYSTEM')
AND cache NOT LIKE 'N%';
even tried changing the AND clause with
AND cache = 'Y';
This SQL works fine, if the AND clause is changed as follows :-
AND cache NOT LIKE '%N';