Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FETCH clause not working...

2776946Jun 2 2015 — edited Jun 2 2015

Running simple statements, for example:

select employee_id, first_name

from employees

order by employee_id

fetch first 5 rows;;

get an ora-00933 error --- SQL command not propery ended.

I am using the standard edition, i'm going to see if this may be the cause, but I don't think this is it...

This post has been answered by James Su on Jun 2 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2015
Added on Jun 2 2015
8 comments
2,426 views