@kevinnay I think this is one instance where a testing thru a VIEW (which is what this evaluate does, limiting the number of lines processed) will not work but the result will still work.
usually on DB Query Reader, the “ORA-00933: SQL command not properly ended” appears if you have included a semicolon on the end of the select statement.
The statement select sysdate from dual runs without issue when I try it in a DB Query Reader.
As @mlauber says, there are times when the mechanism used to preview/evaluate results can have problems because it tries to wrap you query as a subquery/view. If you have any comments, or end of statement character (such as ;) these will cause problems.
If you are still having problems, please post a couple of screenshots of the node config and the errors occurring.