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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with using FETCH in select statement in Oracle 11g

2774845Oct 15 2014 — edited Oct 16 2014

Can any one help me, why i am getting the following error in Oracle 11g with the following query

SELECT repaircost

FROM REPAIRLOG

ORDER BY repaircost desc

FETCH FIRST 5 ROWS ONLY;

ERROR I AM GETTING IS:

FETCH FIRST 5 ROWS ONLY;

ORA-00933: SQL COMMAND NOT PROPERLY ENDED.

Thanks a lot

Danny

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 13 2014

Added on Oct 15 2014

14 comments

25,168 views