0 Replies Latest reply: Jun 21, 2012 4:02 AM by 945039 RSS

    DATABASE LINK  with GROUP BY SQL Statemnets

    945039
      We have Oracle Database Link linked to MySQL . We want to force executing remote statement that contains group by on the remote MySQL server and let MySQL do the aggregation instead of Oracle.
      We tried also DRIVING_SITE but it doesn't help and the query that was sent to MySQL from Oracle DB Link didn't include GROUP BY and it looks like that the Group by was executed on the local Oracle.

      Is there a way for force executing GROUP BY statements on remote DB instead of the local Oracle DB?