This discussion is archived
5 Replies Latest reply: Jul 10, 2012 1:29 AM by mkirtley-Oracle RSS

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

891464 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points