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.
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".
According 11.2 Limits documentation:
Maximum length of SQL statement, including the NULL terminator. 409,600
https://docs.oracle.com/cd/E11882_01/timesten.112/e21643/limit.htm#TTREF455
