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!

can we use DRIVING_SITE hints for multiple remote tables in oracle

858328May 31 2017 — edited Jun 1 2017

Hi All,

  I would like to add my note on Driving_site hint in the discussion.

  can we use this hint for multiple remote tables in single sql query like as below?.

Ex :

   SELECT /*+ DRIVING_SITE(b,c)*/ * FROM emp a,dept@dblink b ,dept2@dblink c

    WHERE a.deptno = b.deptno and c.deptno=b.deptno;

Please advise with your suggestions.

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2017
Added on May 31 2017
8 comments
8,377 views