I'm building a SQL statement that contains data and I'm wondering if I would break some maximum statement length in Oracle 10g.
我正在构建一个包含数据的SQL语句,我想知道我是否会在Oracle 10g中打破一些最大语句长度。
The statement would be about 3 200 000 bytes, cannot be split and has to be parsable in its entirety.
该语句大约为3 200 000字节,不能拆分,必须完整解析。
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.
我正在使用SQL开发人员,但我认为如果服务器可以做到这一点,那么SQL开发人员也可以。
1 个解决方案
#1
10
There is no fixed number. See "Logical Database Limits": http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits003.htm
没有固定的号码。请参阅“逻辑数据库限制”: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".
“SQL语句可以使用多长时间的限制取决于许多因素,包括数据库配置,磁盘空间和内存”。
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".
鉴于PL / SQL过程的最大长度为2000-3000行,我的感觉是你可能遇到3M字节查询的问题。我也认为如果它起作用,解析时间将是“有趣的”。
#1
10
There is no fixed number. See "Logical Database Limits": http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits003.htm
没有固定的号码。请参阅“逻辑数据库限制”: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".
“SQL语句可以使用多长时间的限制取决于许多因素,包括数据库配置,磁盘空间和内存”。
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".
鉴于PL / SQL过程的最大长度为2000-3000行,我的感觉是你可能遇到3M字节查询的问题。我也认为如果它起作用,解析时间将是“有趣的”。