1
votes

This is my query:

select TOPIC,SEQ,INFO FROM HELP WHERE SEQ > 10 ROWNUM <=150

Getting the following exception:

"java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended"

1
missing an AND? - Aleksej
oops... added 'and'.. worked - user2582322

1 Answers

3
votes

Your query is wrong, correct query would be:

select TOPIC,SEQ,INFO FROM HELP WHERE SEQ > 10 AND ROWNUM <=150

Cause of error : Missing AND operator.