5 Replies Latest reply: Jul 10, 2012 3:29 AM by Mkirtley-Oracle RSS

    Oracle to SQL server DB link using rownum to limit result set

    891464
      Hi All,

      I have created a DB link between Oracle 10.2.0.5 to SQL server 2005. Is there any way to limit the number of records from sql server table accessed from oracle using DB link. I tried using rownum but error came that it is not supported in context. The sql server top 5 did not worked as well.

      Kindly help.

      Regards!

      Irfan