Viewing data in Oracle connector stage

[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.

[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?

[sumesh.abraham]

Thanks Ray for the reply. Now I understand that it's set up for a reason