PL/SQL (MOSC)

MOSC Banner

ORA-00933 SQL command not properly ended

edited Jun 4, 2017 5:00AM in PL/SQL (MOSC) 7 commentsAnswered

I am receiving the following error message when attempting to duplicate practice example for Oracle Database 12c: SQL Workshop I 3 -29. Why is this statement not executing. Where is the error stemming from?

SELECT employee_id, first_name

FROM employees

ORDER BY employee_id

FETCH FIRST 5 ROWS ONLY;

ORA-00933: SQL command not properly ended

00933. 00000 -  "SQL command not properly ended"

*Cause:  

*Action:

Error at Line: 4 Column: 1

I located this blurb from https://docs.oracle.com/cd/B10501_01/server.920/a96525/e900.htm

ORA-00933 SQL command not properly ended

Cause: The SQL statement ends with an inappropriate clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center