5 Replies Latest reply on Jul 10, 2012 8:29 AM by Mkirtley-Oracle

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

      Hi All,

      I have created a DB link between Oracle 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.