What is the maximum operator length in Oracle

Question

I am creating an SQL statement containing data, and I am wondering if I will delete one maximum instruction length in Oracle 10g.

The operation will be about 3,200,000 bytes, cannot be divided and should be fully analyzed.

Before I spend too much time this way, I was wondering if I would limit the size of this statement.

I am using an SQL developer, but I think that if the server can do this, then an SQL developer.

Answer 1

There is no fixed number. See "Limitations of the logical database": http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits003.htm

"The limit on how long the SQL statement can work depends on many factors, including database configuration, disk space, and memory."

You may also be affected by other restrictions, such as maximum subquery levels.

Given that the maximum length of PL / SQL procedures is set as 2000-3000 lines, I feel that you may run into problems with a 3 MB query. I also think that if it works at all, the parsing time will be "interesting."