Page 1 of 1

Viewing data in Oracle connector stage

Posted: Fri Oct 07, 2011 12:18 pm
by sumesh.abraham
Hi all,

When viewing the data in Oracle connector stage, it displays only a part of the result set and "fecth more rows" retrieves the next set of records in the resultset and so on. Wondering whether there is any setting that will display all records together without having the need to do "fetch more rows"? Appreciate your help.

Posted: Fri Oct 07, 2011 5:06 pm
by ray.wurlod
Be careful of what you wish for. What happens if you invoke View Data on a table contains many crores of rows?

Or are you being paid by the hour? :wink:

Posted: Mon Oct 10, 2011 10:44 am
by sumesh.abraham
Thanks Ray for the reply. Now I understand that it's set up for a reason :-)