Stepwise-Lab

ORA-00933: SQL command not properly ended

Oracle finished parsing a valid statement but found more text. Common causes: AS before a table alias (Oracle does not allow it), ORDER BY inside one branch of a set operator, or clauses in the wrong order.

On the exam

This error belongs to the topic Basic SELECT of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors