Re: SQL*Plus and MAXDATA

Andrea Pallotta wrote:
>
> Hi there!!
>
> Some people in my group is working with Perl and HTML language to build
> some windows
>
> and access an Oracle 7.1.6 DB in that way.
>
> They build up a very large select ( some tables with many columns ), but
> SQL*Plus don't work and say something about MAXDATA.
>
> The question is simple: It's possible to bypass MAXDATA??
>
> There is a way to buil up large select over the limit of MAXDATA?
>
> Oracle documentation use too few words about this argument!!
>
> Thanks for any help
>
> -------------------------------
> Riccitelli Danilo
> Digital Italia
> Gruppo di sviluppo

Either you can increase the MAXDATA value or decrease the ARRAY value

SET ARRAY 2(default is 15)

Hope this helps

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  Certified Oracle DBA
  WHITTMAN-HART Inc.
  CHICAGO.