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!

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,886 views