In practice, it means that prior to your semi-colon to end the statement, you began with an INSERT statement and ended on the last line with an improper clause, such as ORDER BY, throwing the error message. To correct this issue, simply go back to the end of the phrase and remove the ORDER BY clause.

How do you end a SQL command?

Ending a SQL Command. You can end a SQL command in one of three ways: with a semicolon (;) with a slash (/) on a line by itself.

What is clear command in SQL?

The Clear command clears the screen of the SQL*Plus application window and the screen buffer. Shift+Del is the keyboard shortcut for the Clear command.