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!

driving_site hint and functions

user448703Feb 2 2012 — edited Feb 3 2012
I am using version 11.2.
I am trying to execute a select statement on a table from remote site. My dirving_site hint is getting ignored. I was wondering if any body has any theories about this.

My remote table is remote_tab( col1 varchar2(11), col2 varchar2(6));

-- driving_site hint is not ignored
select /*+ driving_site(rt) */ col1, max(col2) from remote_tab@dblink rt group by col1;

-- driving_site hint ignored
select /*+ driving_site(rt) */ col1, max(to_date(col2, 'RRMMDD')) from remote_tab@dblink rt group by col1;

Any idea on why to_date function causes driving_site hint to be ignored?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2012
Added on Feb 2 2012
2 comments
642 views