Menu
I'm building a SQL statement that contains data and I'm wondering if I would break some maximum statement length in Oracle 10g.
The statement would be about 3 200 000 bytes, cannot be split and has to be parsable in its entirety.
Before I'm investing too much time this way, I was wondering if I would be limited by the size of this statement.
I am using SQL developer but I think that if the server can do it, so can SQL developer.
997
The maximum standard SQL query length is 1024.00K characters, including comments.
In Oracle we can only put up to 1000 values into an IN clause.
For logical table names stored within an Entry table, you can have up to 40 characters. Form names are limited to 100 characters, which is also the Library manager limit on any file name. Section names are limited to 64 characters.
There is no fixed number. See "Logical Database Limits": http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits003.htm
"The limit on how long a SQL statement can be depends on many factors, including database configuration, disk space, and memory".
You might also be affected by other limits, such as the maximum levels of subqueries.
Given that the maximum length of PL/SQL procedures is given as 2000-3000 lines, my feeling is that you may run into problems with a 3M bytes query. I also think that if it works at all, the parse time will be "interesting".
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
