Re: Limit on size of Query?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 12 Apr 2002 18:00:05 -0700
Message-ID: <a97vul031gk@drn.newsguy.com>

In article <ubeskj2bo9173a_at_corp.supernews.com>, "ARP" says...
>
>Is there a known limit on the size (number of characters) of an SQL query
>that can be submitted to the Oracle database engine?
>Is the allowed size determined by where the query is submitted? i.e. is
>there a different limit on the size for queries submitted via SQL Plus as
>opposed to using the Oracle OLEDB provider under program control?
>
>I have been struggling for a little while now with submitting a query that
>is 4571 characters long. How is this problem usually circumvented?
>
>Thanks for your thoughtful responses.
>arp.
>
>

the limits are imposed by the environment but all far exceed 4571 characters for sure.

You can submit *massive* queries if you want to.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Fri Apr 12 2002 - 20:00:05 CDT