What is the maximum query length in Oracle?

If I want to generate dynamically some queries in a php 5 application to retrieve information from an Oracle database. is there a maximum length for this query?

When i use the IN statement, how many values can I use in?

Oct 18 '10 #1

Follow Post Reply

14640

magicwand

11gR2 Reference Guide:

"SQL Statement Length Maximum: length of statements 64 K maximum; particular tools may impose
lower limits"

Oct 18 '10 #2

Similar topics

MySQL Database

Maximum column length

4 posts views Thread by Joe Goh | last post: by

C# / C Sharp

Base64 string from byte array - what's the length ratio ?

2 posts views Thread by Dmitri Shvetsov | last post: by

ASP.NET

Application_Error and Maximum request length exceeded

2 posts views Thread by Jacky Kwok | last post: by

ASP.NET

Catching Exception for "Maximum request length exceeded"

11 posts views Thread by Chris Hayes | last post: by

ASP.NET

Maximum request length exceeded.

2 posts views Thread by Lloyd Dupont | last post: by

.NET Framework

HttpException: Maximum request length exceeded

3 posts views Thread by =?Utf-8?B?UGV0ZXIgU2NobWl0eg==?= | last post: by

ASP.NET

maximum cell length in excel 2000

1 post views Thread by Mike P | last post: by

.NET Framework

Maximum Character Length

5 posts views Thread by toxicpaint | last post: by

.NET Framework

Problem in Passing Query to Oracle using oledb

1 post views Thread by Muhamamd Khayyam | last post: by

PostgreSQL Database

What is the maximum query length in postgresql?

3 posts views Thread by osman7king | last post: by

General

One-click trial on TYK API gateway with Tin

reply views Thread by Trystan | last post: by

General

Which are the best online java code compilers?

2 posts views Thread by davidbuttler | last post: by

Visual Basic 4 / 5 / 6

Convert Amount in to Words

reply views Thread by CoderNitai | last post: by

Microsoft Excel

A tool which can batch import multiple excel files into mysql/oracle database automatically

reply views Thread by ryjfgjl | last post: by

Microsoft Access / VBA

Access Report to Send to Multiple Recipients

3 posts views Thread by kjhyder | last post: by

C# / C Sharp

Operation not allowed on non-connected sockets

reply views Thread by Domgrar | last post: by

General

Is there a Time Standard in programming that actually goes down?

reply views Thread by drunkenHiker | last post: by

Microsoft Access / VBA

Calculator

2 posts views Thread by Eliasendashaw | last post: by

Python

Hi, I'm new here. Help fix this python code.

reply views Thread by DarlinRey | last post: by

What is the maximum query length in Oracle?

Post your reply

Similar topics