Oracle中的最大语句长度是多少 [英] What is the maximum statement length in Oracle

问题描述

我正在构建一个包含数据的SQL语句，我想知道是否会破坏Oracle 10g中的某些最大语句长度.

I'm building a SQL statement that contains data and I'm wondering if I would break some maximum statement length in Oracle 10g.

该语句大约为3,200,000字节，不能拆分，并且必须完全可分析.

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.

我正在使用SQL Developer，但我认为如果服务器可以做到，SQL Developer也可以.

I am using SQL developer but I think that if the server can do it, so can SQL developer.

推荐答案

没有固定数字.请参见逻辑数据库限制": http://docs.oracle. com/cd/B19306_01/server.102/b14237/limits003.htm

There is no fixed number. See "Logical Database Limits": http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits003.htm

"SQL语句可以有多长时间的限制取决于许多因素，包括数据库配置，磁盘空间和内存".

"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.

给定PL/SQL过程的最大长度为2000-3000行，我的感觉是您可能会遇到3M字节查询的问题.我还认为，如果完全可行，解析时间将是有趣的".

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".

这篇关于Oracle中的最大语句长度是多少的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！