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!

Use /* NOPARALLEL */ hint on all of the select

rocky88Aug 8 2018 — edited Aug 8 2018

Hi ,

I have never used /* NOPARALLEL */ hint on select statement , I want to use /* NOPARALLEL */ on below query. I dont know how to use it and what will happen when used this /* NOPARALLEL */ hint .

SELECT *

FROM

(SELECT t.*,

rownum rnum

FROM

(SELECT xxxx || YY AS 'M'

,LL

,KK

,rtrim(www) AS jk

from fgfgfhf

)

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2018

Added on Aug 8 2018

5 comments

4,510 views