| Maximum Query Length [message #125023] |
Wed, 22 June 2005 16:18  |
kapil2005
Messages: 44
Registered: March 2005
|
Member |
|
|
What is the Maximum Query length that oracle can run and what is my Maximum query length that sqlplus can handle. i have a query that is just a select statement 2.10 MB, can oracle run that query in oracle 9205 hp unix.
thanks
|
|
|
|
|
|
| Re: Maximum Query Length [message #125030 is a reply to message #125023] |
Wed, 22 June 2005 17:21  |
kapil2005
Messages: 44
Registered: March 2005
|
Member |
|
|
I Know it makes curious, but I don’t know the query is built dynamically, it just have some sub queries and lot of logical “and” & “or” in where clause, so i want to know what is the Maximum query length or size.
Thanks for looking into
|
|
|
|
|
|
| Re: Maximum Query Length [message #125141 is a reply to message #125023] |
Thu, 23 June 2005 09:26 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I did a quick scan through the reference guide and didn't see a limit, although I haven't done a more extensive internet search. I'm pretty sure that there is a limit on the length of a single line in a query, but I don't know whether or not there is a limit on the query itself provided the lines were short enough. I don't think there is, but what happens when you run it, and save me the trouble of coming up with a test case?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
