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!

ORA-00907: missing right parenthesis

Rajesh123Aug 17 2017 — edited Aug 21 2017

Hi All,

I am trying to order by clause using CASE function using 2 columns.

But i am getting "ORA-00907: missing right parenthesis"

Order by

CASE :P_DATA

WHEN 1 then order_number,Order_qty

WHEN 2 then Order_qty,Order_sac

END;

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

Could you please help me on this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2017

Added on Aug 17 2017

18 comments

2,095 views