470,596 Members | 1,474 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

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
1 14640
11gR2 Reference Guide:

"SQL Statement Length Maximum: length of statements 64 K maximum; particular tools may impose
lower limits"
Oct 18 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Joe Goh | last post: by
2 posts views Thread by Lloyd Dupont | last post: by
3 posts views Thread by =?Utf-8?B?UGV0ZXIgU2NobWl0eg==?= | last post: by
1 post views Thread by Mike P | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.